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:
| Field | Type | Null | Key | Default | Description |
|---|---|---|---|---|---|
db | char(64) | NO | PRI | Database name. | |
name | char(64) | NO | PRI | Routine name. | |
type | enum('FUNCTION','PROCEDURE','PACKAGE', 'PACKAGE BODY') | NO | PRI | NULL | Whether stored procedure, stored function or, from MariaDB 10.3.5, a package or package body. |
specific_name | char(64) | NO | |||
language | enum('SQL') | NO | SQL | Always SQL. | |
sql_data_access | enum('CONTAINS_SQL', 'NO_SQL', 'READS_SQL_DATA', 'MODIFIES_SQL_DATA') | NO | CONTAINS_SQL | ||
is_deterministic | enum('YES','NO') | NO | NO | Whether the routine is deterministic (can produce only one result for a given list of parameters) or not. | |
security_type | enum('INVOKER','DEFINER') | NO | DEFINER | INVOKER or DEFINER. Indicates which user's privileges apply to this routine. | |
param_list | blob | NO | NULL | List of parameters. | |
returns | longblob | NO | NULL | What the routine returns. | |
body | longblob | NO | NULL | Definition of the routine. | |
definer | char(141) | NO | If the security_type is DEFINER, this value indicates which user defined this routine. | ||
created | timestamp | NO | CURRENT_TIMESTAMP | Date and time the routine was created. | |
modified | timestamp | NO | 0000-00-00 00:00:00 | Date and time the routine was modified. | |
sql_mode | set('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') | NO | The SQL_MODE at the time the routine was created. | ||
comment | text | NO | NULL | Comment associated with the routine. | |
character_set_client | char(32) | YES | NULL | The character set used by the client that created the routine. | |
collation_connection | char(32) | YES | NULL | The collation (and character set) used by the connection that created the routine. | |
db_collation | char(32) | YES | NULL | The default collation (and character set) for the database, at the time the routine was created. | |
body_utf8 | longblob | YES | NULL | Definition of the routine in utf8. | |
aggregate | enum('NONE', 'GROUP') | NO | NONE | From MariaDB 10.3.3 | |
| Field | Type | Null | Key | Default | Description |
See Also
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
