mysql> mysql> mysql> delimiter // mysql> create procedure myproc (in in_count int) -> begin -> declare count int default 0; -> -> increment: loop -> set count = count + 1; -> if count < 20 then iterate increment; end if; -> if count > in_count then leave increment; -> end if; -> end loop increment; -> -> select count; -> end -> // query ok, 0 rows affected (0.00 sec) mysql> delimiter ; mysql> mysql> call myproc(5); +-------+ | count | +-------+ | 20 | +-------+ 1 row in set (0.00 sec) query ok, 0 rows affected (0.00 sec) mysql> mysql> drop procedure myproc; query ok, 0 rows affected (0.00 sec) mysql>