mysql循环语句的例子：Repeat until loop

分享下mysql中unitl循环的用法实例，供大家参考。

代码如下：

mysql> delimiter //
mysql> create procedure test_repeat (IN in_count INT) //创建一个mysql存储过程
    -> BEGIN
    ->     declare count INT default 0;
    ->
    ->     increment: repeat
    ->         set count = count + 1;
    ->         select count;
    ->         until count > 10
    ->     end repeat increment;
    ->
    -> END
    -> //
Query OK, 0 rows affected (0.00 sec)

mysql> delimiter ;
mysql> call test_repeat(10); //调用mysql存储过程
+-------+
| count |
+-------+
|     1 |
+-------+
1 row in set (0.00 sec)

+-------+
| count |
+-------+
|     2 |
+-------+
1 row in set (0.00 sec)

+-------+
| count |
+-------+
|     3 |
+-------+
1 row in set (0.01 sec)

+-------+
| count |
+-------+
|     4 |
+-------+
1 row in set (0.01 sec)

+-------+
| count |
+-------+
|     5 |
+-------+
1 row in set (0.01 sec)

+-------+
| count |
+-------+
|     6 |
+-------+
1 row in set (0.01 sec)

+-------+
| count |
+-------+
|     7 |
+-------+
1 row in set (0.01 sec)

+-------+
| count |
+-------+
|     8 |
+-------+
1 row in set (0.01 sec)

+-------+
| count |
+-------+
|     9 |
+-------+
1 row in set (0.01 sec)

+-------+
| count |
+-------+
|    10 |
+-------+
1 row in set (0.01 sec)

+-------+
| count |
+-------+
|    11 |
+-------+
1 row in set (0.01 sec)

Query OK, 0 rows affected (0.01 sec)

mysql>
mysql> drop procedure test_repeat; //删除mysql存储过程
Query OK, 0 rows affected (0.00 sec)

您可能感兴趣的文章：
mysql循环语句的例子：Repeat until loop
mysql存储过程中的三种循环
mysql实例 循环结构中使用if语句
mysql实例 repeat语句的用法
分享:Mysql 5.0存储过程学习总结
使用循环语句
mysql函数中使用repeat循环的例子
asp do while 循环语法与do while实例教程
mysql存储过程中使用游标的实例详解
mysql存储过程学习笔记分享