mysql> select * from tables where table_name="jd_level" limit 1\G
*************************** 1. row ***************************
TABLE_CATALOG: def
TABLE_SCHEMA: jingdiantravel
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>
评论