| TABLE_CATALOG |
varchar(512)
|
utf8_general_ci
|
|
|
| TABLE_SCHEMA |
varchar(64)
|
utf8_general_ci
|
|
|
| TABLE_NAME |
varchar(64)
|
utf8_general_ci
|
|
|
| TABLE_TYPE |
varchar(64)
|
utf8_general_ci
|
|
|
| ENGINE |
varchar(64)
|
utf8_general_ci
|
|
|
| VERSION |
bigint(21)
|
|
|
|
| ROW_FORMAT |
varchar(10)
|
utf8_general_ci
|
|
|
| TABLE_ROWS |
bigint(21)
|
|
|
|
| AVG_ROW_LENGTH |
bigint(21)
|
|
|
|
| DATA_LENGTH |
bigint(21)
|
|
|
|
| MAX_DATA_LENGTH |
bigint(21)
|
|
|
|
| INDEX_LENGTH |
bigint(21)
|
|
|
|
| DATA_FREE |
bigint(21)
|
|
|
|
| AUTO_INCREMENT |
bigint(21)
|
|
|
|
| CREATE_TIME |
datetime
|
|
|
|
| UPDATE_TIME |
datetime
|
|
|
|
| CHECK_TIME |
datetime
|
|
|
|
| TABLE_COLLATION |
varchar(32)
|
utf8_general_ci
|
|
 参照されている値を表示する
|
| CHECKSUM |
bigint(21)
|
|
|
|
| CREATE_OPTIONS |
varchar(2048)
|
utf8_general_ci
|
|
|
| TABLE_COMMENT |
varchar(2048)
|
utf8_general_ci
|
|
|
| MAX_INDEX_LENGTH |
bigint(21)
|
|
|
|
| TEMPORARY |
varchar(1)
|
utf8_general_ci
|
|
|
