| SPECIFIC_NAME |
varchar(64)
|
utf8_general_ci
|
|
|
| ROUTINE_CATALOG |
varchar(64)
|
utf8_bin
|
|
|
| ROUTINE_SCHEMA |
varchar(64)
|
utf8_bin
|
|
|
| ROUTINE_NAME |
varchar(64)
|
utf8_general_ci
|
|
|
| ROUTINE_TYPE |
enum('FUNCTION', 'PROCEDURE')
|
utf8_bin
|
|
|
| DATA_TYPE |
longtext
|
utf8_bin
|
|
|
| CHARACTER_MAXIMUM_LENGTH |
bigint(21)
|
|
|
|
| CHARACTER_OCTET_LENGTH |
bigint(21)
|
|
|
|
| NUMERIC_PRECISION |
int(10)
|
|
|
|
| NUMERIC_SCALE |
int(10)
|
|
|
|
| DATETIME_PRECISION |
int(10)
|
|
|
|
| CHARACTER_SET_NAME |
varchar(64)
|
utf8_general_ci
|
|
|
| COLLATION_NAME |
varchar(64)
|
utf8_general_ci
|
|
 浏览不相关的值
|
| DTD_IDENTIFIER |
longtext
|
utf8_bin
|
|
|
| ROUTINE_BODY |
varchar(3)
|
utf8_general_ci
|
|
|
| ROUTINE_DEFINITION |
longtext
|
utf8_bin
|
|
|
| EXTERNAL_NAME |
binary(0)
|
|
|
|
| EXTERNAL_LANGUAGE |
varchar(64)
|
utf8_bin
|
|
|
| PARAMETER_STYLE |
varchar(3)
|
utf8_general_ci
|
|
|
| IS_DETERMINISTIC |
varchar(3)
|
utf8_general_ci
|
|
|
| SQL_DATA_ACCESS |
enum('CONTAINS SQL', 'NO SQL', 'READS SQL DATA', 'MODIFIES SQL DATA')
|
utf8_bin
|
|
|
| SQL_PATH |
binary(0)
|
|
|
|
| SECURITY_TYPE |
enum('DEFAULT', 'INVOKER', 'DEFINER')
|
utf8_bin
|
|
|
| CREATED |
timestamp
|
|
|
|
| LAST_ALTERED |
timestamp
|
|
|
|
| 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', 'NOT_USED_9', 'NOT_USED_10', 'NOT_USED_11', 'NOT_USED_12', 'NOT_USED_13', 'NOT_USED_14', 'NOT_USED_15', 'NOT_USED_16', 'NOT_USED_17', 'NOT_USED_18', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'ALLOW_INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NOT_USED_29', 'HIGH_NOT_PRECEDENCE', 'NO_ENGINE_SUBSTITUTION', 'PAD_CHAR_TO_FULL_LENGTH', 'TIME_TRUNCATE_FRACTIONAL')
|
utf8_bin
|
|
|
| ROUTINE_COMMENT |
text
|
utf8_bin
|
|
|
| DEFINER |
varchar(288)
|
utf8_bin
|
|
|
| CHARACTER_SET_CLIENT |
varchar(64)
|
utf8_general_ci
|
|
|
| COLLATION_CONNECTION |
varchar(64)
|
utf8_general_ci
|
|
浏览不相关的值
|
| DATABASE_COLLATION |
varchar(64)
|
utf8_general_ci
|
|
浏览不相关的值
|
