ITERATE MYSQL 例子_介绍MySQL的Iterate迭代语句实例代码

在学习MySQL的时候，我们需要知道些什么，要注意哪些问题，下面我们来介绍 MySQL 的 Iterate 迭代语句。mysql>

mysql>

mysql> DELIMITER //

mysql> CREATE PROCEDURE myProc (IN in_count INT)

-> BEGIN

-> DECLARE count INT default 0;

->

-> increment: LOOP

-> SET count = count + 1;

-> IF count < 20 THEN ITERATE increment; END IF;

-> IF count > in_count THEN LEAVE increment;

-> END IF;

-> END LOOP increment;

->

-> SELECT count;

-> END

-> //

Query OK, 0 rows affected (0.00 sec)

mysql> DELIMITER ;

mysql>

mysql> call myProc(5);

+-------+

| count |

+-------+

| 20 |

+-------+

1 row in set (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql>

mysql> drop procedure myProc;

Query OK, 0 rows affected (0.00 sec)

mysql>