MySQL Storage process 5:while

Loop structure whileCreate procedurename ()begin     whileconditional do SQL statementsEnd  while; End$Create procedureaa6 ()begin      Declare  Number int default 0;  while  Number < 5 DoSelect  Number; Set  Number =  Number + 1; End  while; End$


Mysql> CREATE PROCEDURE Aa6 ()
Begin
-Declare number int default 0;
, while number < 5 do
Select number;
Set Number = number + 1;
and end while;
end$
Query OK, 0 rows Affected (0.00 sec)

Mysql> Call aa6$
+--------+
| number |
+--------+
| 0 |
+--------+
1 row in Set (0.00 sec)

+--------+
| number |
+--------+
| 1 |
+--------+
1 row in Set (0.01 sec)

+--------+
| number |
+--------+
| 2 |
+--------+
1 row in Set (0.01 sec)

+--------+
| number |
+--------+
| 3 |
+--------+
1 row in Set (0.01 sec)

+--------+
| number |
+--------+
| 4 |
+--------+
1 row in Set (0.02 sec)

Query OK, 0 rows affected (0.02 sec)

MySQL Storage process 5:while