• SHOW TABLE STATUS
    • 语法图
    • 示例
    • MySQL 兼容性
    • 另请参阅

    SHOW TABLE STATUS

    SHOW TABLE STATUS 语句用于显示 TiDB 中表的各种统计信息。如果显示统计信息过期，建议运行 ANALYZE TABLE。

    语法图

    ShowStmt:

    ShowStmt

    ShowTargetFilterable:

    ShowTargetFilterable

    ShowDatabaseNameOpt:

    ShowDatabaseNameOpt

    示例

    1. mysql> CREATE TABLE t1 (id INT NOT NULL PRIMARY KEY auto_increment, c1 INT NOT NULL);
    2. Query OK, 0 rows affected (0.11 sec)
    4. mysql> INSERT INTO t1 (c1) VALUES (1),(2),(3),(4),(5);
    5. Query OK, 5 rows affected (0.02 sec)
    6. Records: 5  Duplicates: 0  Warnings: 0
    8. mysql> SHOW TABLE STATUS LIKE 't1'\G
    9. *************************** 1. row ***************************
    10.            Name: t1
    11.          Engine: InnoDB
    12.         Version: 10
    13.      Row_format: Compact
    14.            Rows: 0
    15.  Avg_row_length: 0
    16.     Data_length: 0
    17. Max_data_length: 0
    18.    Index_length: 0
    19.       Data_free: 0
    20.  Auto_increment: 30001
    21.     Create_time: 2019-04-19 08:32:06
    22.     Update_time: NULL
    23.      Check_time: NULL
    24.       Collation: utf8mb4_bin
    25.        Checksum: 
    26.  Create_options: 
    27.         Comment: 
    28. 1 row in set (0.00 sec)
    30. mysql> analyze table t1;
    31. Query OK, 0 rows affected (0.12 sec)
    33. mysql> SHOW TABLE STATUS LIKE 't1'\G
    34. *************************** 1. row ***************************
    35.            Name: t1
    36.          Engine: InnoDB
    37.         Version: 10
    38.      Row_format: Compact
    39.            Rows: 5
    40.  Avg_row_length: 16
    41.     Data_length: 80
    42. Max_data_length: 0
    43.    Index_length: 0
    44.       Data_free: 0
    45.  Auto_increment: 30001
    46.     Create_time: 2019-04-19 08:32:06
    47.     Update_time: NULL
    48.      Check_time: NULL
    49.       Collation: utf8mb4_bin
    50.        Checksum: 
    51.  Create_options: 
    52.         Comment: 
    53. 1 row in set (0.00 sec)

    MySQL 兼容性

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

    另请参阅

    • SHOW TABLES
    • CREATE TABLE
    • DROP TABLE
    • SHOW CREATE TABLE