:: DEVELOPER ZONE
MySQL Reference Manual :: 13.5.4.17 SHOW TABLE STATUS Syntax
Search the MySQL manual:
- 13.5.4 SHOW Syntax
- 13.5.4.1 SHOW CHARACTER SET Syntax
- 13.5.4.2 SHOW COLLATION Syntax
- 13.5.4.3 SHOW COLUMNS Syntax
- 13.5.4.4 SHOW CREATE DATABASE Syntax
- 13.5.4.5 SHOW CREATE TABLE Syntax
- 13.5.4.6 SHOW DATABASES Syntax
- 13.5.4.7 SHOW ENGINE Syntax
- 13.5.4.8 SHOW ENGINES Syntax
- 13.5.4.9 SHOW ERRORS Syntax
- 13.5.4.10 SHOW GRANTS Syntax
- 13.5.4.11 SHOW INDEX Syntax
- 13.5.4.12 SHOW INNODB STATUS Syntax
- 13.5.4.13 SHOW LOGS Syntax
- 13.5.4.14 SHOW PRIVILEGES Syntax
- 13.5.4.15 SHOW PROCESSLIST Syntax
- 13.5.4.16 SHOW STATUS Syntax
- 13.5.4.17 SHOW TABLE STATUS Syntax
- 13.5.4.18 SHOW TABLES Syntax
- 13.5.4.19 SHOW VARIABLES Syntax
- 13.5.4.20 SHOW WARNINGS Syntax
Additional languages
Additional formats
SHOW TABLE STATUS [FROMdb_name] [LIKE 'pattern']
SHOW TABLE STATUS works likes SHOW
TABLE, but provides a lot of information about each
table. You can also get this list using the mysqlshow
--status db_name command. This
statement was added in MySQL 3.23. As of MySQL 5.0.1, it also
displays information about views.
SHOW TABLE STATUS returns the following fields:
-
NameThe name of the table.
-
EngineThe storage engine for the table. Before MySQL 4.1.2, this value is labeled as
Type. See Chapter 14, MySQL Storage Engines and Table Types. -
VersionThe version number of the table's
.frmfile. -
Row_formatThe row storage format (
Fixed,Dynamic,Compressed,Redundant,Compact). Starting with MySQL/InnoDB 5.0.3, the format of InnoDB tables is reported asRedundantorCompact. Before 5.0.3, InnoDB tables are always in theRedundantformat. -
RowsThe number of rows. Some storage engines, such as
MyISAMandISAM, store the exact count.For other storage engines, such as
InnoDB, this value is an approximation, and may vary from the actual value by as much as 40 to 50%. In such cases, useSELECT COUNT(*)to obtain an accurate count.The
Rowsvalue isNULLfor tables in theINFORMATION_SCHEMAdatabase. -
Avg_row_lengthThe average row length.
-
Data_lengthThe length of the data file.
-
Max_data_lengthThe maximum length of the data file. This is the total number of data bytes that can be stored in the table, given the data pointer size used.
-
Index_lengthThe length of the index file.
-
Data_freeThe number of allocated but unused bytes.
-
Auto_incrementThe next
AUTO_INCREMENTvalue. -
Create_timeWhen the table was created.
-
Update_timeWhen the data file was last updated.
-
Check_timeWhen the table was last checked.
-
CollationThe table's character set and collation. (New in 4.1.1)
-
ChecksumThe live checksum value (if any). (New in 4.1.1)
-
Create_optionsExtra options used with
CREATE TABLE. -
CommentThe comment used when creating the table (or some information why MySQL couldn't access the table information).
In the table comment, InnoDB tables report the
free space of the tablespace to which the table belongs. For a
table located in the shared tablespace, this is the free space of
the shared tablespace. If you are using multiple tablespaces and
the table has its own tablespace, the free space is for just that
table.
For MEMORY (HEAP) tables, the
Data_length, Max_data_length,
and Index_length values approximate the actual
amount of allocated memory. The allocation algorithm reserves
memory in large amounts to reduce the number of allocation
operations.
For views, all the fields displayed by SHOW TABLE
STATUS are NULL except that
Name indicates the view name and
Comment says view.
© 1995-2005 MySQL AB. All rights reserved.
User Comments
Warning: query failed: Unknown column 'user.firstname' in 'field list' in /data0/sites/live/web-main/lib/mysql-cxn.php on line 69
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /data0/sites/live/web-main/lib/docbook.php on line 245
Add your own comment.