mysql> mysql> mysql> mysql> mysql> SHOW CREATE PROCEDURE test.myProcG *************************** 1. row *************************** Procedure: myProc sql_mode: Create Procedure: CREATE DEFINER=`root`@`localhost` 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;