LEAVE with Label out of an inner loop : LEAVE : Procedure Function MySQL TUTORIALS


MySQL TUTORIALS » Procedure Function » LEAVE »

 

LEAVE with Label out of an inner loop


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, rows affected (0.00 sec)

mysql>
mysql> delimiter ;
mysql> call myProc();
+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 1                    |
+-----------------------------------+
row in set (0.02 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 2                    |
+-----------------------------------+
row in set (0.02 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 3                    |
+-----------------------------------+
row in set (0.02 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 4                    |
+-----------------------------------+
row in set (0.03 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 5                    |
+-----------------------------------+
row in set (0.03 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 6                    |
+-----------------------------------+
row in set (0.03 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 7                    |
+-----------------------------------+
row in set (0.03 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 8                    |
+-----------------------------------+
row in set (0.03 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 9                    |
+-----------------------------------+
row in set (0.38 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times 10 is 10                  |
+-----------------------------------+
row in set (0.38 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times 11 is 11                  |
+-----------------------------------+
row in set (0.38 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times 12 is 12                  |
+-----------------------------------+
row in set (0.39 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 2                    |
+-----------------------------------+
row in set (0.39 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 4                    |
+-----------------------------------+
row in set (0.39 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 6                    |
+-----------------------------------+
row in set (0.39 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 8                    |
+-----------------------------------+
row in set (0.39 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 10                   |
+-----------------------------------+
row in set (0.39 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 12                   |
+-----------------------------------+
row in set (0.39 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 14                   |
+-----------------------------------+
row in set (0.39 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 16                   |
+-----------------------------------+
row in set (0.41 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 18                   |
+-----------------------------------+
row in set (0.41 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times 10 is 20                  |
+-----------------------------------+
row in set (0.41 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times 11 is 22                  |
+-----------------------------------+
row in set (0.41 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times 12 is 24                  |
+-----------------------------------+
row in set (0.78 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 3                    |
+-----------------------------------+
row in set (0.78 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 6                    |
+-----------------------------------+
row in set (0.78 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 9                    |
+-----------------------------------+
row in set (0.78 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 12                   |
+-----------------------------------+
row in set (0.78 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 15                   |
+-----------------------------------+
row in set (0.78 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 18                   |
+-----------------------------------+
row in set (0.80 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 21                   |
+-----------------------------------+
row in set (0.80 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 24                   |
+-----------------------------------+
row in set (0.80 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 27                   |
+-----------------------------------+
row in set (0.80 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times 10 is 30                  |
+-----------------------------------+
row in set (0.80 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times 11 is 33                  |
+-----------------------------------+
row in set (0.80 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times 12 is 36                  |
+-----------------------------------+
row in set (0.80 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 4                    |
+-----------------------------------+
row in set (0.81 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 8                    |
+-----------------------------------+
row in set (1.22 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 12                   |
+-----------------------------------+
row in set (1.22 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 16                   |
+-----------------------------------+
row in set (1.22 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 20                   |
+-----------------------------------+
row in set (1.22 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 24                   |
+-----------------------------------+
row in set (1.22 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 28                   |
+-----------------------------------+
row in set (1.22 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 32                   |
+-----------------------------------+
row in set (1.22 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 36                   |
+-----------------------------------+
row in set (1.23 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times 10 is 40                  |
+-----------------------------------+
row in set (1.23 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times 11 is 44                  |
+-----------------------------------+
row in set (1.23 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times 12 is 48                  |
+-----------------------------------+
row in set (1.23 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 5                    |
+-----------------------------------+
row in set (1.23 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 10                   |
+-----------------------------------+
row in set (1.23 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 15                   |
+-----------------------------------+
row in set (1.23 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 20                   |
+-----------------------------------+
row in set (1.23 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 25                   |
+-----------------------------------+
row in set (1.64 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 30                   |
+-----------------------------------+
row in set (1.66 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 35                   |
+-----------------------------------+
row in set (1.66 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 40                   |
+-----------------------------------+
row in set (1.66 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 45                   |
+-----------------------------------+
row in set (1.66 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times 10 is 50                  |
+-----------------------------------+
row in set (1.66 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times 11 is 55                  |
+-----------------------------------+
row in set (1.66 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times 12 is 60                  |
+-----------------------------------+
row in set (1.66 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 6                    |
+-----------------------------------+
row in set (1.66 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 12                   |
+-----------------------------------+
row in set (1.66 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 18                   |
+-----------------------------------+
row in set (1.67 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 24                   |
+-----------------------------------+
row in set (1.67 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 30                   |
+-----------------------------------+
row in set (1.67 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 36                   |
+-----------------------------------+
row in set (1.67 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 42                   |
+-----------------------------------+
row in set (1.67 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 48                   |
+-----------------------------------+
row in set (2.14 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 54                   |
+-----------------------------------+
row in set (2.14 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times 10 is 60                  |
+-----------------------------------+
row in set (2.14 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times 11 is 66                  |
+-----------------------------------+
row in set (2.14 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times 12 is 72                  |
+-----------------------------------+
row in set (2.16 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 7                    |
+-----------------------------------+
row in set (2.16 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 14                   |
+-----------------------------------+
row in set (2.16 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 21                   |
+-----------------------------------+
row in set (2.16 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 28                   |
+-----------------------------------+
row in set (2.16 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 35                   |
+-----------------------------------+
row in set (2.16 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 42                   |
+-----------------------------------+
row in set (2.16 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 49                   |
+-----------------------------------+
row in set (2.16 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 56                   |
+-----------------------------------+
row in set (2.16 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 63                   |
+-----------------------------------+
row in set (2.16 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times 10 is 70                  |
+-----------------------------------+
row in set (2.17 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times 11 is 77                  |
+-----------------------------------+
row in set (2.64 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times 12 is 84                  |
+-----------------------------------+
row in set (2.64 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 8                    |
+-----------------------------------+
row in set (2.64 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 16                   |
+-----------------------------------+
row in set (2.66 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 24                   |
+-----------------------------------+
row in set (2.66 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 32                   |
+-----------------------------------+
row in set (2.66 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 40                   |
+-----------------------------------+
row in set (2.66 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 48                   |
+-----------------------------------+
row in set (2.66 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 56                   |
+-----------------------------------+
row in set (2.66 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 64                   |
+-----------------------------------+
row in set (2.66 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 72                   |
+-----------------------------------+
row in set (2.66 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times 10 is 80                  |
+-----------------------------------+
row in set (2.66 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times 11 is 88                  |
+-----------------------------------+
row in set (2.67 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times 12 is 96                  |
+-----------------------------------+
row in set (2.67 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 9                    |
+-----------------------------------+
row in set (2.67 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 18                   |
+-----------------------------------+
row in set (3.14 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 27                   |
+-----------------------------------+
row in set (3.14 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 36                   |
+-----------------------------------+
row in set (3.16 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 45                   |
+-----------------------------------+
row in set (3.16 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 54                   |
+-----------------------------------+
row in set (3.16 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 63                   |
+-----------------------------------+
row in set (3.16 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 72                   |
+-----------------------------------+
row in set (3.16 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times is 81                   |
+-----------------------------------+
row in set (3.16 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times 10 is 90                  |
+-----------------------------------+
row in set (3.16 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times 11 is 99                  |
+-----------------------------------+
row in set (3.17 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
times 12 is 108                 |
+-----------------------------------+
row in set (3.17 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
10 times is 10                  |
+-----------------------------------+
row in set (3.17 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
10 times is 20                  |
+-----------------------------------+
row in set (3.17 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
10 times is 30                  |
+-----------------------------------+
row in set (3.17 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
10 times is 40                  |
+-----------------------------------+
row in set (3.17 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
10 times is 50                  |
+-----------------------------------+
row in set (3.64 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
10 times is 60                  |
+-----------------------------------+
row in set (3.66 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
10 times is 70                  |
+-----------------------------------+
row in set (3.66 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
10 times is 80                  |
+-----------------------------------+
row in set (3.66 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
10 times is 90                  |
+-----------------------------------+
row in set (3.66 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
10 times 10 is 100                |
+-----------------------------------+
row in set (3.67 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
10 times 11 is 110                |
+-----------------------------------+
row in set (3.67 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
10 times 12 is 120                |
+-----------------------------------+
row in set (3.67 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
11 times is 11                  |
+-----------------------------------+
row in set (3.67 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
11 times is 22                  |
+-----------------------------------+
row in set (3.69 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
11 times is 33                  |
+-----------------------------------+
row in set (3.69 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
11 times is 44                  |
+-----------------------------------+
row in set (3.69 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
11 times is 55                  |
+-----------------------------------+
row in set (3.69 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
11 times is 66                  |
+-----------------------------------+
row in set (3.69 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
11 times is 77                  |
+-----------------------------------+
row in set (3.69 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
11 times is 88                  |
+-----------------------------------+
row in set (4.14 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
11 times is 99                  |
+-----------------------------------+
row in set (4.14 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
11 times 10 is 110                |
+-----------------------------------+
row in set (4.16 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
11 times 11 is 121                |
+-----------------------------------+
row in set (4.16 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
11 times 12 is 132                |
+-----------------------------------+
row in set (4.16 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
12 times is 12                  |
+-----------------------------------+
row in set (4.16 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
12 times is 24                  |
+-----------------------------------+
row in set (4.16 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
12 times is 36                  |
+-----------------------------------+
row in set (4.16 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
12 times is 48                  |
+-----------------------------------+
row in set (4.16 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
12 times is 60                  |
+-----------------------------------+
row in set (4.16 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
12 times is 72                  |
+-----------------------------------+
row in set (4.17 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
12 times is 84                  |
+-----------------------------------+
row in set (4.17 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
12 times is 96                  |
+-----------------------------------+
row in set (4.17 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
12 times is 108                 |
+-----------------------------------+
row in set (4.17 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
12 times 10 is 120                |
+-----------------------------------+
row in set (4.17 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
12 times 11 is 132                |
+-----------------------------------+
row in set (4.66 sec)

+-----------------------------------+
| CONCAT(i," times ", j," is ",i*j|
+-----------------------------------+
12 times 12 is 144                |
+-----------------------------------+
row in set (4.66 sec)

Query OK, rows affected (4.66 sec)

mysql> drop procedure myProc;
Query OK, rows affected (0.00 sec)

mysql>



Leave a Comment / Note


 
Verification is used to prevent unwanted posts (spam). .

Follow Navioo On Twitter

MySQL TUTORIALS

 Navioo Procedure Function
» LEAVE