MySQL的LEAVE语句退出循环

无详细内容 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

mysql>
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();