我们可以借助show table status语句检查数据库中表的状态。例如,在名为tutorial的数据库中,通过执行此语句,我们可以获得表的状态,如下所示:
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)
该数据库只有一个名为“ student”的表。