Get table information in MySQL Show table status

Usage
Mysql>show table status;
Mysql>show table status like ' Esf_seller_history ' \g;

Mysql>show table status like ' esf_% ' \g;

Example:

Mysql>show table status like ' Esf_seller_history ' \g;

1.Name
Table name
2.Engine:
Table's Storage Engine
3.Version:
Version number
4.row_format
The row format.

For the MyISAM engine, this may be dynamic. Fixed or compressed. Dynamic lines have variable line lengths, such as varchar or BLOB type fields. A fixed row is a constant line length, such as a char and an integer type field.

5. Rows
The number of rows in the table.

For non-transactional tables, this value is accurate and, for transactional engines, this value is generally estimated.
6.avg_row_length
Average number of bytes per row
7.data_length
The amount of data (in bytes) of the entire table
8.max_data_length
The maximum amount of data the table can hold
9.index_length
The amount of space the index occupies on the disk
10.data_free
For the MyISAM engine, the identity is assigned. But the unused space is now available. It also includes space for deleted rows.
11.auto_increment
The value of the next auto_increment
12.create_time
When the table was created
13.update_time
Time of recent update of table
14.check_time
Check the short-term time of a table using the Check table or Myisamchk tool
15.Collation
Default character set and character collation for tables
16.Checksum
Assume enabled. The checksum of the entire table's contents when computed
17.create_options
All other options when the table is created
18.Comment
Other additional information is included. For the MyISAM engine, including the gaze Xu Peoni, assume that the table uses the InnoDB engine, which will be the remaining space of the actual table.

The assumption is a view. The gaze includes the word view.

Get table information in MySQL Show table status