ITERATE MYSQL 例子,MySQL 使用 LOOP 的 ITERATE 语句示例

介绍 MySQL 的 Iterate 迭代语句 MySQL mysqlmysqlmysql 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 I

介绍 MySQL 的 Iterate 迭代语句

MySQL

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>

本文原创发布php中文网，转载请注明出处，感谢您的尊重！