(mysql.info) statistics-table
Info Catalog
(mysql.info) columns-table
(mysql.info) information-schema
(mysql.info) user-privileges-table
20.4 The `INFORMATION_SCHEMA STATISTICS' Table
==============================================
The `STATISTICS' table provides information about table indexes.
*`INFORMATION_SCHEMA' Name* *`SHOW' Name* *Remarks*
`TABLE_CATALOG' `NULL'
`TABLE_SCHEMA' = Database
`TABLE_NAME' `Table'
`NON_UNIQUE' `Non_unique'
`INDEX_SCHEMA' = Database
`INDEX_NAME' `Key_name'
`SEQ_IN_INDEX' `Seq_in_index'
`COLUMN_NAME' `Column_name'
`COLLATION' `Collation'
`CARDINALITY' `Cardinality'
`SUB_PART' `Sub_part' MySQL extension
`PACKED' `Packed' MySQL extension
`NULLABLE' `Null' MySQL extension
`INDEX_TYPE' `Index_type' MySQL extension
`COMMENT' `Comment' MySQL extension
Notes:
* There is no standard table for indexes. The preceding list is
similar to what SQL Server 2000 returns for `sp_statistics',
except that we replaced the name `QUALIFIER' with `CATALOG' and we
replaced the name `OWNER' with `SCHEMA'.
Clearly, the preceding table and the output from `SHOW INDEX' are
derived from the same parent. So the correlation is already close.
The following statements are equivalent:
SELECT * FROM INFORMATION_SCHEMA.STATISTICS
WHERE table_name = 'TBL_NAME'
[AND table_schema = 'DB_NAME']
SHOW INDEX
FROM TBL_NAME
[FROM DB_NAME]
Info Catalog
(mysql.info) columns-table
(mysql.info) information-schema
(mysql.info) user-privileges-table
automatically generated byinfo2html