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