mysql.proc Table

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.

MariaDB starting with 10.4

In MariaDB 10.4 and later, this table uses the Aria storage engine.

MariaDB until 10.3

In MariaDB 10.3 and before, this table uses the MyISAM storage engine.

The mysql.proc table contains the following fields:

FieldTypeNullKeyDefaultDescription
dbchar(64)NOPRIDatabase name.
namechar(64)NOPRIRoutine name.
typeenum('FUNCTION','PROCEDURE','PACKAGE', 'PACKAGE BODY')NOPRINULLWhether stored procedure, stored function or, from MariaDB 10.3.5, a package or package body.
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', 'EMPTY_STRING_IS_NULL', 'SIMULTANEOUS_ASSIGNMENT')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.
aggregateenum('NONE', 'GROUP')NONONEFrom MariaDB 10.3.3
FieldTypeNullKeyDefaultDescription

See Also

Comments

Comments loading...