MySQL 的 LEAVE 语句退出循环
程序员文章站
2024-01-17 17:23:10
...
无详细内容 MySQL mysqlmysql delimiter $$mysqlmysql CREATE PROCEDURE myProc() - BEGIN - DECLARE i,j INT DEFAULT 1; - outer_loop: LOOP - SET j=1; - inner_loop: LOOP - SELECT CONCAT(i," times ", j," is ",i*j); - SET j=j+1; - IF j12 THEN - LEAV
MySQLmysql> mysql> delimiter $$ mysql> mysql> CREATE PROCEDURE myProc() -> BEGIN -> DECLARE i,j INT DEFAULT 1; -> outer_loop: LOOP -> SET j=1; -> inner_loop: LOOP -> SELECT CONCAT(i," times ", j," is ",i*j); -> SET j=j+1; -> IF j>12 THEN -> LEAVE inner_loop; -> END IF; -> END LOOP inner_loop; -> SET i=i+1; -> IF i>12 THEN -> LEAVE outer_loop; -> END IF; -> END LOOP outer_loop; -> -> -> -> END$$ Query OK, 0 rows affected (0.00 sec) mysql> mysql> delimiter ; mysql> call myProc();