mysql>mysql> delimiter //mysql> create procedure test_repeat (IN in_count INT) -> BEGIN -> declare count INT default 0; -> -> increment: repeat -> set count = count + 1; -> select count; -> until count > 10 -> end repeat increment; -> -> END -> //Query OK, 0 rows affected (0.00 sec)mysql>mysql> delimiter ;mysql>mysql> call test_repeat(10);+-------+| count |+-------+| 1 |+-------+1 row in set (0.00 sec)+-------+| count |+-------+| 2 |+-------+1 row in set (0.00 sec)+-------+| count |+-------+| 3 |+-------+1 row in set (0.01 sec)+-------+| count |+-------+| 4 |+-------+1 row in set (0.01 sec)+-------+| count |+-------+| 5 |+-------+1 row in set (0.01 sec)+-------+| count |+-------+| 6 |+-------+1 row in set (0.01 sec)+-------+| count |+-------+| 7 |+-------+1 row in set (0.01 sec)+-------+| count |+-------+| 8 |+-------+1 row in set (0.01 sec)+-------+| count |+-------+| 9 |+-------+1 row in set (0.01 sec)+-------+| count |+-------+| 10 |+-------+1 row in set (0.01 sec)+-------+| count |+-------+| 11 |+-------+1 row in set (0.01 sec)Query OK, 0 rows affected (0.01 sec)mysql>mysql> drop procedure test_repeat;Query OK, 0 rows affected (0.00 sec)
Name (required)
email (will not be published) (required)
Website