mysql> select * from tables where table_name="jd_level" limit 1\G
*************************** 1. row ***************************
TABLE_CATALOG: def
TABLE_SCHEMA: jd
TABLE_NAME: jd_level
TABLE_TYPE: BASE TABLE
ENGINE: MyISAM
VERSION: 10
ROW_FORMAT: Dynamic
TABLE_ROWS: 23660
AVG_ROW_LENGTH: 193
DATA_LENGTH: 4574436
MAX_DATA_LENGTH: 281474976710655
INDEX_LENGTH: 2081792
DATA_FREE: 0
AUTO_INCREMENT: 23668
CREATE_TIME: 2013-11-11 15:13:07
UPDATE_TIME: 2013-11-11 15:13:09
CHECK_TIME: 2013-11-11 15:13:09
TABLE_COLLATION: gbk_chinese_ci
CHECKSUM: NULL
CREATE_OPTIONS:
TABLE_COMMENT:
1 row in set (0.76 sec)
mysql>
mysql 查看建表时间,表大小
于 2017-05-27 22:16:24 首次发布