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

We can check the status of tables in a database with the help of show table status statement. For example, in the database named tutorial, by executing this statement we can get the status of tables 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)

This database is having only one table named ‘student’.

varma

Updated on 22-Jun-2020 04:56:12

• Related Questions & Answers
• How Can I check the size of the tables in a particular MySQL database?
• How can we check the character set of all the tables in a particular MySQL database?
• How to check statement of creating a particular MySQL database?
• Get a list of non-empty tables in a particular MySQL database?
• How can I check the character set of all the tables along with column names in a particular MySQL database?
• How can I check MySQL tables from a database in accordance with particular column/s name?
• How can we analyze the tables of a particular database from MySQL Server command line?
• How can we check the default character sets of a particular MySQL database?
• How to count the number of tables in a MySQL database?
• How to get the size of the tables of a MySQL database?
• How can we get the list of tables in a particular database from MySQL Server command line?
• How to alter the database engine of a MySQL database table?
• How to check an empty table already in a MySQL database?
• How can I check the status of MySQL Server?
• Create a stored procedure to get the detail of a particular MySQL table stored in a database?