mysql Óï¾ä´íÎó - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

CREATE PROCEDURE dowhile()
BEGIN
  DECLARE v1 INT DEFAULT 5;
  WHILE v1 > 0 DO
  SET v1 = v1 - 1;
  END WHILE;
END

ÎÒÔËÐÐmysql°ïÖúÀïÃæµÄ³ÌÐò»á±¨´í£¬²»ÖªµÀΪʲô£¬ÇëÖªµÀµÄ¸æËßÎÒÒ»ÏÂ

´íÎó´úÂë: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INT DEFAULT 5' at line 3
(ºÄ·Ñ 0 ms)

´íÎó´úÂë: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHILE v1 > 0 DO
  SET v1 = v1 - 1' at line 1
(ºÄ·Ñ 0 ms)

´íÎó´úÂë: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END WHILE' at line 1
(ºÄ·Ñ 0 ms)

´íÎó´úÂë: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END' at line 1
(ºÄ·Ñ 0 ms)

---

ѧϰ¡£¡£¡£

---

ÎÒÔËÐÐȷʵ±¨´í£¬ÎÒÔÚsqlyogÀïÃæÔËÐеģ¬mysql°æ±¾ÊÇ5.0.22µÄ

---

ÆäʵÎÒÏëÑ­»·µÄд²åÈëÓï¾ä£¬ÖªµÀÔõôдµÄ´ó¸ç£¬Âé·³¸æËßÎÒ°¡

---

ÎÒÖ´ÐÐ
mysql> delimiter ;
mysql>
mysql> call dowhile;
ûÓз´Ó¦

---

SQL code:
mysql&