- 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();
- --该片段来自于http://www.codesnippet.cn/detail/12112012260.html
来源: http://www.codesnippet.cn/detail/12112012260.html