Mysql儲存過程5: while

標籤：default   nbsp   cal   class   ber   div   結構   end   font   

迴圈結構 whilecreate procedure name()  begin    while 條件 do      SQL語句    end while;  end$create procedure aa6()    begin      declare number int default 0;      while number < 5 do        select 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;
    ->         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儲存過程5: while