delimiter $$
mysql>
mysql> CREATE PROCEDURE myProc() //å建while循ç¯çåå¨è¿ç¨ ifåæ¯è¯å¥ç¤ºä¾
-> BEGIN
->
-> DECLARE i int;
-> SET i=1;
-> loop1: WHILE i<=10 DO
-> IF MOD(i,2)<>0 THEN /*Even number - try again*/
-> SELECT CONCAT(i," is an odd number");
-> END IF;
-> SET i=i+1;
-> END WHILE loop1;
-> END$$
Query OK, 0 rows affected (0.00 sec)
è¿ç§ä¹å¯ä»¥
温馨提示:答案为网友推荐,仅供参考