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. Row_format: Compact
    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. Update_time: NULL
    13. Collation: utf8mb4_bin
    14. Checksum:
    15. Create_options:
    16. Comment:
    17. 1 row in set (0.00 sec)
    1. Query OK, 0 rows affected (0.12 sec)
    1. SHOW TABLE STATUS LIKE 't1';

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