SHOW TABLE STATUS
ShowTableStatusStmt:
FromOrIn:
StatusTableName:
Query OK, 0 rows affected (0.11 sec)
INSERT INTO t1 (c1) VALUES (1),(2),(3),(4),(5);
SHOW TABLE STATUS LIKE 't1';
*************************** 1. row ***************************
Name: t1
Engine: InnoDB
Rows: 0
Avg_row_length: 0
Data_length: 0
Max_data_length: 0
Index_length: 0
Data_free: 0
Auto_increment: 30001
Create_time: 2019-04-19 08:32:06
Collation: utf8mb4_bin
Checksum:
Create_options:
Comment:
1 row in set (0.00 sec)
Query OK, 0 rows affected (0.12 sec)
SHOW TABLE STATUS LIKE 't1';
语句与 MySQL 完全兼容。如发现任何兼容性差异,请在 GitHub 上提交 。