MySQL 存储过程中使用 WHILE 循环语句

mysql>

02	mysql> delimiter $$

03

mysql>

04	mysql> CREATE PROCEDURE myProc()

05

-> BEGIN

06

->

07	->     DECLARE i int;

08	->     SET i=1;

09	->     loop1: WHILE i<=10 DO

10	->          IF MOD(i,2)<>0 THEN /*Even number - try again*/

11	->             SELECT CONCAT(i," is an odd number");

12	->          END IF;

13	->          SET i=i+1;

14	->     END WHILE loop1;

15

-> END$$

16	Query OK, 0 rows affected (0.00 sec)

17

18

mysql>

19	mysql> delimiter ;

20	mysql> call myProc();

举报