MySQL 使用 LOOP 的 ITERATE 语句示例
程序员文章站
2022-05-02 21:46:31
...
介绍 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 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>
上一篇: Linux C代码实现cgi shell
下一篇: MySQL 主从复制的原理和配置