COLUMNS

mmt
FieldTypeNullKeyDefaultExtra
TABLE_CATALOG varchar(64) NO
TABLE_SCHEMA varchar(64) NO
TABLE_NAME varchar(64) NO
COLUMN_NAME varchar(64) YES
ORDINAL_POSITION int(10) unsigned NO
COLUMN_DEFAULT text YES
IS_NULLABLE varchar(3) NO
DATA_TYPE longtext YES
CHARACTER_MAXIMUM_LENGTH bigint(21) YES
CHARACTER_OCTET_LENGTH bigint(21) YES
NUMERIC_PRECISION bigint(10) unsigned YES
NUMERIC_SCALE bigint(10) unsigned YES
DATETIME_PRECISION int(10) unsigned YES
CHARACTER_SET_NAME varchar(64) YES
COLLATION_NAME varchar(64) YES
COLUMN_TYPE mediumtext NO
COLUMN_KEY enum('','PRI','UNI','MUL') NO
EXTRA varchar(57) YES
PRIVILEGES varchar(154) YES
COLUMN_COMMENT text NO
GENERATION_EXPRESSION longtext NO
SRS_ID int(10) unsigned YES
[ START ][ Connect ] [ create table form ]

MySQL Nippon Association