- Name: Table name
- Engine: Table's storage engines (the value is type in the old version)
- Row_format: The format of the row. For MyISAM tables, the optional values are dynamic, fixed, or copressed.
- Dynamic: variable length, typically containing variable-length fields, if varchar or blob.
- fixed: fix length, containing only fixed-length columns, such as char and Integer.
- compressed: Only exists in the compressed table
- rows: The number of rows in the table. For MyISAM and some other storage engines, this value is accurate, but for InnoDB the value is estimated.
- Avg_row_length: Average number of bytes per row
- data_length: Table data Size (in bytes)
- max_data_length: Maximum capacity of table data, and storage engine-related /li>
- index_length: Size of index
- data_free: For the MyISAM table, represents the space that has been allocated but is not currently used. This part of the space contains the previously deleted rows, as well as the space that can be used for subsequent inserts.
- auto_increment: The value of the next auto_increment.
- create_time: Table creation time
- update_time: Last Modified time for table data
- check_time: Using Ckeck The table command or the time that the Myisamchk tool last checked the tables.
- Collation: The default character set and character column collation for the table.
- Checksum: If enabled, the real-time checksum of the entire table is saved.
- create_options: Other options specified when the table was created.
- coment: This column contains some additional information. For MyISAM tables, the notes that accompany the table when it was created are saved, and the remaining space information for the InnoDB table space is saved for the InnoDB table. If it is a view, the column contains the text of the view.
Detailed description of each column of the MySQL SHOW TABLE output
