proc
Table comments: Stored Procedures| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| db | char(64) | No | ||
| name | char(64) | No | ||
| type | enum('FUNCTION', 'PROCEDURE') | No | ||
| 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 | longblob | 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_ENGINE_SUBSTITUTION', 'PAD_CHAR_TO_FULL_LENGTH') | No | ||
| comment | text | No | ||
| character_set_client | char(32) | Yes | NULL | |
| collation_connection | char(32) | Yes | NULL | |
| db_collation | char(32) | Yes | NULL | |
| body_utf8 | longblob | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | db | A | No | ||
| name | A | No | ||||||
| type | 0 | A | No |
Space usage:
| Row Statistics:
|