mysql> mysql> mysql> ALTER PROCEDURE myProc SQL SECURITY INVOKER -> COMMENT 'This is my procedure'; Query OK, 0 rows affected (0.00 sec)
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: INVOKER 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:35 modified: 2007-07-23 18:58:35 sql_mode: comment: This is my procedure 1 row in set (0.00 sec)