The stored procedure characteristics include a number of options for how the stored procedure behaves. : Procedure « Procedure Function « MySQL Tutorial






  1. MySQL Tutorial
  2. Procedure Function
  3. Procedure

The following table lists the available options.

CharacteristicValueDescription
LANGUAGESQLThe language used to write the stored procedure.
SQL SECURITYDEFINER or INVOKERThe SQL SECURITY tells MySQL which user to use when running the procedure. The default is DEFINER.
COMMENTThe COMMENT is a place to enter notes. The comment is displayed in SHOW CREATE PROCEDURE commands.










11.5.Procedure
11.5.1.The CREATE PROCEDURE Statement
11.5.2.You can set parameters for a stored procedure
11.5.3.Using an OUT parameter.
11.5.4.The stored procedure characteristics include a number of options for how the stored procedure behaves.
11.5.5.Creating a Single-Statement Procedure
11.5.6.Calling a Single-Statement Procedure
11.5.7.Creating a Multistatement Stored Procedure
11.5.8.The ALTER statement lets you change the characteristics of a stored procedure
11.5.9.To remove a stored procedures, use the DROP statement
11.5.10.ALTER PROCEDURE and ALTER FUNCTION Syntax
11.5.11.DROP PROCEDURE and DROP FUNCTION Syntax
11.5.12.Stored Procedure Permissions