Syntax error What information does SHOW TABLE DOES display in MySQL

What information does SHOW TABLE DOES display in MySQL

The SHOW TABLE STATUS in MySQL displays the NAME, ENGINE, VERSION, ROWS, CHECKSUM, etc of a table −

Example

Let us first create a table. Here, we are using the MyISAM engine. The query to create a 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 check the table status using SHOW TABLE command. The query is as follows −

mysql> show table status where Name = 'Post_Demo'\G

Output

*************************** 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)
Updated on: 2020-03-06T10:05:22+05:30

139 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements