MySQL Tutorial/Data Dictionary/proc
proc
mysql> desc proc;
+------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------------------+-------+
| db | char(64) | NO | PRI | | |
| name | char(64) | NO | PRI | | |
| type | enum("FUNCTION","PROCEDURE") | NO | PRI | | |
| specific_name | char(64) | NO | | | |
| language | enum("SQL") | NO | | 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 | |
| security_type | enum("INVOKER","DEFINER") | NO | | DEFINER | |
| param_list | blob | NO | | | |
| returns | char(64) | NO | | | |
| body | longblob | NO | | | |
| definer | char(77) | NO | | | |
| created | timestamp | NO | | CURRENT_TIMESTAMP | |
| modified | timestamp | NO | | 0000-00-00 00:00:00 | |
| sql_mode | set("REAL_AS_FLOAT","PIPES_AS_CONCAT","ANSI_QUOTES","IGNORE_SPACE","NOT_USED","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 | | | |
| comment | char(64) | NO | | | |
+------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------------------+-------+
16 rows in set (0.02 sec)
mysql> use test
Database changed