mysql.proc Table
You are viewing an old version of this article. View
the current version here.
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:
| Field | Type | Null | Key | Default | Description |
|---|---|---|---|---|---|
db | char(64) | NO | PRI | Database name. | |
name | char(64) | NO | PRI | Routine name. | |
type | enum('FUNCTION','PROCEDURE') | NO | PRI | NULL | Whether stored procedure or stored function. |
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') | 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. |
See also
Comments
Comments loading...
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.
