Procedure Function MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Procedure Function
  4. 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.