mysql> mysql> mysql> mysql> SELECT * FROM mysql.proc WHERE name = 'myProc'G *************************** 1. row *************************** db: test name: myProc type: PROCEDURE specific_name: myProc language: SQL sql_data_access: CONTAINS_SQL is_deterministic: NO security_type: DEFINER param_list: IN in_count INT returns: body: 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 definer: root@localhost created: 2007-07-23 18:58:34 modified: 2007-07-23 18:58:34 sql_mode: comment: 1 row in set (0.00 sec)