- Documentation Library
- Table of Contents
- MySQL 6.0 Reference Manual
- MySQL 5.1 Reference Manual
- MySQL 5.0 Reference Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
MySQL 5.0 Reference Manual :: 12 SQL Statement Syntax :: 12.1 Data Definition Statements :: 12.1.2 ALTER PROCEDURE and ALTER FUNCTION
Syntax
Section Navigation [Toggle]
- 12.1 Data Definition Statements
- 12.1.1 ALTER DATABASE Syntax
- 12.1.2 ALTER PROCEDURE and ALTER FUNCTION Syntax
- 12.1.3 ALTER TABLE Syntax
- 12.1.4 ALTER VIEW Syntax
- 12.1.5 CREATE DATABASE Syntax
- 12.1.6 CREATE FUNCTION Syntax
- 12.1.7 CREATE INDEX Syntax
- 12.1.8 CREATE PROCEDURE and CREATE FUNCTION Syntax
- 12.1.9 CREATE TABLE Syntax
- 12.1.10 CREATE TRIGGER Syntax
- 12.1.11 CREATE VIEW Syntax
- 12.1.12 DROP DATABASE Syntax
- 12.1.13 DROP FUNCTION Syntax
- 12.1.14 DROP INDEX Syntax
- 12.1.15 DROP PROCEDURE and DROP FUNCTION Syntax
- 12.1.16 DROP TABLE Syntax
- 12.1.17 DROP TRIGGER Syntax
- 12.1.18 DROP VIEW Syntax
- 12.1.19 RENAME TABLE 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
Section 17.5, “Binary Logging of Stored Programs”.
More than one change may be specified in an ALTER
PROCEDURE or ALTER FUNCTION
statement.
© 1995-2008 MySQL AB, 2008 Sun Microsystems, Inc.
User Comments
Add your own comment.