Show Table status in Mysql method to get table information _mysql

How to use

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

Sample Example:

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

1.Name

Table name

2.Engine:

Table's Storage Engine

3.Version:

Version

4.row_format

Row format. For MyISAM engines, this could be dynamic,fixed or compressed. The length of a dynamic row is variable, such as a varchar or blob type field. Fixed rows are the same length of rows, such as char and integer type fields.

5. Rows

The number of rows in the table. For non-transactional tables, this value is accurate, and for transactional engines, this value is usually estimated.

6.avg_row_length

Average number of bytes per line included

7.data_length

Amount of data in the entire table (in bytes)

8.max_data_length

Maximum amount of data that a table can hold

9.index_length

Index occupies disk space size

10.data_free

For the MyISAM engine, identifies the space that has been allocated but is not currently in use, and contains the space for the deleted row.

11.auto_increment

The value of the next auto_increment

12.create_time

When the table was created

13.update_time

Last Update time of table

14.check_time

To check the most recent time of a table using the check table or the Myisamchk tool

15.Collation

Default character set and character collation for tables

16.Checksum

If enabled, the checksum for the contents of the entire table is calculated

17.create_options

All other options when the table is created

18.Comment

Contains additional information, for the MyISAM engine, contains annotation Xu Peoni, if the table is using the InnoDB engine, the remaining space of the reality table. If it is a

View, and the comment contains the word view.

The above content is small to introduce the MySQL Show table status Get table information method, I hope to help!