W3cubDocs

/MariaDB

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.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/mysqlproc-table/