The mysql.proc table contains information about stored procedures and stored functions. It contains similar information to that stored in the INFORMATION SCHEMA.ROUTINES table.

It contains the following fields:

FieldTypeNullKeyDefaultDescription
dbchar(64)NOPRIDatabase name.
namechar(64)NOPRIRoutine name.
typeenum('FUNCTION','PROCEDURE')NOPRINULLWhether stored procedure or stored function.
specific_namechar(64)NO
languageenum('SQL')NOSQLAlways SQL.
sql_data_accessenum('CONTAINS_SQL', 'NO_SQL', 'READS_SQL_DATA', 'MODIFIES_SQL_DATA')NOCONTAINS_SQL
is_deterministicenum('YES','NO')NONOWhether the routine is deterministic (can produce only one result for a given list of parameters) or not.
security_typeenum('INVOKER','DEFINER')NODEFINERINVOKER or DEFINER. Indicates which user's privileges apply to this routine.
param_listblobNONULLList of parameters.
returnslongblobNONULLWhat the routine returns.
bodylongblobNONULLDefinition of the routine.
definerchar(141)NOIf the security_type is DEFINER, this value indicates which user defined this routine.
createdtimestampNOCURRENT_TIMESTAMPDate and time the routine was created.
modifiedtimestampNO0000-00-00 00:00:00Date and time the routine was modified.
sql_modeset('REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTES', 'IGNORE_SPACE', 'IGNORE_BAD_TABLE_OPTIONS', 'ONLY_FULL_GROUP_BY', 'NO_UNSIGNED_SUBTRACTION', 'NO_DIR_IN_CREATE', 'POSTGRESQL', 'ORACLE', 'MSSQL', 'DB2', 'MAXDB', 'NO_KEY_OPTIONS', 'NO_TABLE_OPTIONS', 'NO_FIELD_OPTIONS', 'MYSQL323', 'MYSQL40', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NO_AUTO_CREATE_USER', 'HIGH_NOT_PRECEDENCE', 'NO_ENGINE_SUBSTITUTION', 'PAD_CHAR_TO_FULL_LENGTH')NOThe SQL_MODE at the time the routine was created.
commenttextNONULLComment associated with the routine.
character_set_clientchar(32)YESNULLThe character set used by the client that created the routine.
collation_connectionchar(32)YESNULLThe collation (and character set) used by the connection that created the routine.
db_collationchar(32)YESNULLThe default collation (and character set) for the database, at the time the routine was created.
body_utf8longblobYESNULLDefinition of the routine in utf8.

See also

Comments

Comments loading...