Method of using While loop statement in Mysql stored procedure _mysql

This example describes a method for using a while loop statement in a MySQL stored procedure. Share to everyone for your reference. Specifically as follows:

mysql>
mysql> delimiter $$
mysql>
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 a odd number");
 -> end   IF;
 ->   SET i=i+1;
 -> End While  Loop1;
 -> end$$
Query OK, 0 rows Affected (0.00 sec)
mysql> mysql>
;
Mysql> call MyProc ();

I hope this article is helpful to the design of MySQL database.