proc : proc « Data Dictionary « MySQL Tutorial






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








25.10.proc
25.10.1.proc