TABLE_CATALOG
|
varchar(512)
|
utf8_general_ci
|
|
|
TABLE_SCHEMA
|
varchar(64)
|
utf8_general_ci
|
|
|
TABLE_NAME
|
varchar(64)
|
utf8_general_ci
|
|
|
COLUMN_NAME
|
varchar(64)
|
utf8_general_ci
|
|
|
ORDINAL_POSITION
|
bigint(21)
|
|
|
|
COLUMN_DEFAULT
|
longtext
|
utf8_general_ci
|
|
|
IS_NULLABLE
|
varchar(3)
|
utf8_general_ci
|
|
|
DATA_TYPE
|
varchar(64)
|
utf8_general_ci
|
|
|
CHARACTER_MAXIMUM_LENGTH
|
bigint(21)
|
|
|
|
CHARACTER_OCTET_LENGTH
|
bigint(21)
|
|
|
|
NUMERIC_PRECISION
|
bigint(21)
|
|
|
|
NUMERIC_SCALE
|
bigint(21)
|
|
|
|
DATETIME_PRECISION
|
bigint(21)
|
|
|
|
CHARACTER_SET_NAME
|
varchar(32)
|
utf8_general_ci
|
|
|
COLLATION_NAME
|
varchar(32)
|
utf8_general_ci
|
|
浏览不相关的值
|
COLUMN_TYPE
|
longtext
|
utf8_general_ci
|
|
|
COLUMN_KEY
|
varchar(3)
|
utf8_general_ci
|
|
|
EXTRA
|
varchar(27)
|
utf8_general_ci
|
|
|
PRIVILEGES
|
varchar(80)
|
utf8_general_ci
|
|
|
COLUMN_COMMENT
|
varchar(1024)
|
utf8_general_ci
|
|
|