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.01 sec)mysql>mysql>mysql> SHOW PROCEDURE STATUSG*************************** 1. row *************************** Db: test Name: myProc Type: PROCEDURE Definer: root@localhost Modified: 2007-07-23 18:58:34 Created: 2007-07-23 18:58:34Security_type: DEFINER Comment:*************************** 2. row *************************** Db: test Name: simpleproc Type: PROCEDURE Definer: root@localhost Modified: 2007-07-17 18:50:06 Created: 2007-07-17 18:50:06Security_type: DEFINER Comment:2 rows in set (0.02 sec)mysql>mysql>mysql> drop procedure myProc;Query OK, 0 rows affected (0.00 sec)mysql>mysql>
Name (required)
email (will not be published) (required)
Website