How to check the table status of a table in a specific MySQL database?

#We can use the show table status statement to check the status of the table in the database. For example, in the database named tutorial, by executing this statement we can get the status of the table as follows -

mysql> show table status \G

*************************** 1. row ***************************
           Name: student
         Engine: InnoDB
        Version: 10
     Row_format: Compact
           Rows: 0
 Avg_row_length: 0
    Data_length: 16384
Max_data_length: 0
   Index_length: 0
      Data_free: 7340032
 Auto_increment: NULL
    Create_time: 2017-10-24 09:34:29
    Update_time: NULL
     Check_time: NULL
      Collation: latin1_swedish_ci
       Checksum: NULL
 Create_options:
        Comment:
1 row in set (0.00 sec)

The database has only one table named "student".

The above is the detailed content of How to check the table status of a table in a specific MySQL database?. For more information, please follow other related articles on the PHP Chinese website!