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