Show Table Status

Syntax: Show table status [{from | in}Db_name] [Like'Pattern'| WhereExpr]

Show Table StatusWorks likesShow tables, But provides a lot of information about each non-TemporaryTable. You can also get this list usingMysqlshow -- StatusDb_nameCommand.LikeClause, if present, indicates which table names to match.

Show Table StatusThe following fields are returned:

Name	Table Name
Engine	Table storage engine. Before MySQL 4.1.2, this value is marked as type.
Version	Version number of the. frm file of the table
Row_format	Row Storage Format (fixed, dynamic, compressed, redundant, compact ). The InnoDB table format is reported as redundant or compact.
Rows	The number of rows. Some storage engines, such as MyISAM, store precise numbers. For other storage engines, such as InnoDB, the current value is an approximate number, which is 40 to 50% different from the actual value. In these cases, select count (*) is used to obtain the exact number. For tables in the information_schema database, the rows value is null.
Avg_row_length	The average length of a row.
Data_length	The length of the data file.
Max_data_length	The maximum length of the data file. Given the Data Pointer size, this is the total number of bytes of data that can be stored in the table.
Index_length	The length of the index file.
Data_free	Number of unused bytes in the ascending order.
Auto_increment	The next auto_increment value.
Create_time	Table creation time.
Update_time	When is the data file last updated?
Check_time	When is the table last checked. Not all storage engines are updated at this time. In this case, the value is null.
Collation	The character set and collation of the table.
Checksum	Activity verification value.
Create_options	And create table.
comment	comments used to create a table (or descriptions on why MySQL can access table information ).