PARTITIONS

mmt
FieldTypeNullKeyDefaultExtra
TABLE_CATALOG varchar(64) NO
TABLE_SCHEMA varchar(64) NO
TABLE_NAME varchar(64) NO
PARTITION_NAME varchar(64) YES
SUBPARTITION_NAME varchar(64) YES
PARTITION_ORDINAL_POSITION int(6) unsigned YES
SUBPARTITION_ORDINAL_POSITION int(6) unsigned YES
PARTITION_METHOD varchar(13) YES
SUBPARTITION_METHOD varchar(13) YES
PARTITION_EXPRESSION varchar(2048) YES
SUBPARTITION_EXPRESSION varchar(2048) YES
PARTITION_DESCRIPTION text YES
TABLE_ROWS bigint(21) unsigned YES
AVG_ROW_LENGTH bigint(21) unsigned YES
DATA_LENGTH bigint(21) unsigned YES
MAX_DATA_LENGTH bigint(21) unsigned YES
INDEX_LENGTH bigint(21) unsigned YES
DATA_FREE bigint(21) unsigned YES
CREATE_TIME timestamp NO CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
UPDATE_TIME datetime YES
CHECK_TIME datetime YES
CHECKSUM bigint(21) YES
PARTITION_COMMENT text NO
NODEGROUP varchar(256) YES
TABLESPACE_NAME varchar(259) YES
[ START ][ Connect ] [ create table form ]

MySQL Nippon Association