SHOW TABLE STATUS

    ShowTableStatusStmt:

    FromOrIn:

    StatusTableName:

    1. Query OK, 0 rows affected (0.11 sec)
    1. INSERT INTO t1 (c1) VALUES (1),(2),(3),(4),(5);
    1. SHOW TABLE STATUS LIKE 't1';
    1. *************************** 1. row ***************************
    2. Name: t1
    3. Engine: InnoDB
    4. Rows: 0
    5. Avg_row_length: 0
    6. Data_length: 0
    7. Max_data_length: 0
    8. Index_length: 0
    9. Data_free: 0
    10. Auto_increment: 30001
    11. Create_time: 2019-04-19 08:32:06
    12. Collation: utf8mb4_bin
    13. Checksum:
    14. Create_options:
    15. Comment:
    16. 1 row in set (0.00 sec)
    1. Query OK, 0 rows affected (0.12 sec)
    1. SHOW TABLE STATUS LIKE 't1';

    语句与 MySQL 完全兼容。如发现任何兼容性差异,请在 GitHub 上提交 。