(mysql.info) alter-procedure

Info Catalog

(mysql.info) create-procedure

(mysql.info) stored-procedure-syntax

(mysql.info) drop-procedure

 
 17.2.2 `ALTER PROCEDURE' and `ALTER FUNCTION' Syntax
 ----------------------------------------------------
 
      ALTER {PROCEDURE | FUNCTION} SP_NAME [CHARACTERISTIC ...]
 
      CHARACTERISTIC:
          { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }
        | SQL SECURITY { DEFINER | INVOKER }
        | COMMENT 'STRING'
 
 This statement can be used to change the characteristics of a stored
 procedure or function. As of MySQL 5.0.3, you must have the `ALTER
 ROUTINE' privilege for the routine.  (That privilege is granted
 automatically to the routine creator.) If binary logging is enabled,
 this statement might also require the `SUPER' privilege, as described
 in  stored-procedure-logging.
 
 More than one change may be specified in an `ALTER PROCEDURE' or `ALTER
 FUNCTION' statement.
 

Info Catalog

(mysql.info) create-procedure

(mysql.info) stored-procedure-syntax

(mysql.info) drop-procedure