Use the WHILE loop statement _ MySQL in the MySQL stored procedure

Use the WHILE loop statement in the MySQL stored procedure Use the WHILE loop statement _ MySQL in the MySQL stored procedure

Mysql> delimiter $ mysql> create procedure myProc ()-> 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) mysql> delimiter; mysql> call myProc ();

The above is the content of the WHILE loop statement _ MySQL used in the MySQL stored procedure. For more information, see PHP Chinese network (www.php1.cn )!