mysql> select * from information_schema.tables
-> where table_name='test2'
-> \G
*************************** 1. row ***************************
TABLE_CATALOG: NULL
TABLE_SCHEMA: test
TABLE_NAME: test2
TABLE_TYPE: BASE TABLE
ENGINE: InnoDB
VERSION: 10
ROW_FORMAT: Compact
TABLE_ROWS: 473168
AVG_ROW_LENGTH: 74
DATA_LENGTH: 35209216
MAX_DATA_LENGTH: 0
INDEX_LENGTH: 14221312
DATA_FREE: 0
AUTO_INCREMENT: NULL
CREATE_TIME: 2006-12-29 13:02:11
UPDATE_TIME: NULL
CHECK_TIME: NULL
TABLE_COLLATION: latin1_swedish_ci
CHECKSUM: NULL
CREATE_OPTIONS:
TABLE_COMMENT: InnoDB free: 56320 kB
1 row in set (1.03 sec)
mysql> select * from information_schema.tables
-> where table_name='test2'
-> \G
*************************** 1. row ***************************
TABLE_CATALOG: NULL
TABLE_SCHEMA: test
TABLE_NAME: test2
TABLE_TYPE: BASE TABLE
ENGINE: InnoDB
VERSION: 10
ROW_FORMAT: Compact
TABLE_ROWS: 514558
AVG_ROW_LENGTH: 68
DATA_LENGTH: 35209216
MAX_DATA_LENGTH: 0
INDEX_LENGTH: 14221312
DATA_FREE: 0
AUTO_INCREMENT: NULL
CREATE_TIME: 2006-12-29 13:02:11
UPDATE_TIME: NULL
CHECK_TIME: NULL
TABLE_COLLATION: latin1_swedish_ci
CHECKSUM: NULL
CREATE_OPTIONS:
TABLE_COMMENT: InnoDB free: 56320 kB
1 row in set (0.42 sec)
mysql> select * from information_schema.tables
-> where table_name='test2'
-> \G
*************************** 1. row ***************************
TABLE_CATALOG: NULL
TABLE_SCHEMA: test
TABLE_NAME: test2
TABLE_TYPE: BASE TABLE
ENGINE: InnoDB
VERSION: 10
ROW_FORMAT: Compact
TABLE_ROWS: 336482
AVG_ROW_LENGTH: 104
DATA_LENGTH: 35209216
MAX_DATA_LENGTH: 0
INDEX_LENGTH: 14221312
DATA_FREE: 0
AUTO_INCREMENT: NULL
CREATE_TIME: 2006-12-29 13:02:11
UPDATE_TIME: NULL
CHECK_TIME: NULL
TABLE_COLLATION: latin1_swedish_ci
CHECKSUM: NULL
CREATE_OPTIONS:
TABLE_COMMENT: InnoDB free: 56320 kB
1 row in set (0.58 sec)
Partager