In MySQL, the SHOW TABLE STATUS command displays the table name, engine, version, number of rows, checksum and other information −
First let's create a table. Here, we are using the MyISAM engine. The query to create the table is as follows -
mysql> create table Post_Demo -> ( -> PostId int, -> PostName varchar(100), -> PostDate datetime, -> PRIMARY KEY(PostId) -> )ENGINE = MyISAM; Query OK, 0 rows affected (0.28 sec)
Now you can use the SHOW TABLE command to check the status of the table. The query is as follows −
mysql> show table status where Name = 'Post_Demo'\G
*************************** 1. row *************************** Name: post_demo Engine: MyISAM Version: 10 Row_format: Dynamic Rows: 0 Avg_row_length: 0 Data_length: 0 Max_data_length: 281474976710655 Index_length: 1024 Data_free: 0 Auto_increment: 1 Create_time: 2019-02-12 16:27:26 Update_time: 2019-02-12 16:27:26 Check_time: NULL Collation: utf8_general_ci Checksum: NULL Create_options: Comment: 1 row in set (0.00 sec)
The above is the detailed content of What information does SHOW TABLE display in MySQL?. For more information, please follow other related articles on the PHP Chinese website!