Mega Code Archive

 

Categories / MySQL Tutorial / Procedure Function

 

The stored procedure characteristics include a number of options for how the stored procedure behaves

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.