- 12.4.5 SHOW Syntax
- 12.4.5.1 SHOW BINARY LOGS Syntax
- 12.4.5.2 SHOW BINLOG EVENTS Syntax
- 12.4.5.3 SHOW CHARACTER SET Syntax
- 12.4.5.4 SHOW COLLATION Syntax
- 12.4.5.5 SHOW COLUMNS Syntax
- 12.4.5.6 SHOW CREATE DATABASE Syntax
- 12.4.5.7 SHOW CREATE FUNCTION Syntax
- 12.4.5.8 SHOW CREATE PROCEDURE Syntax
- 12.4.5.9 SHOW CREATE TABLE Syntax
- 12.4.5.10 SHOW CREATE VIEW Syntax
- 12.4.5.11 SHOW DATABASES Syntax
- 12.4.5.12 SHOW ENGINE Syntax
- 12.4.5.13 SHOW ENGINES Syntax
- 12.4.5.14 SHOW ERRORS Syntax
- 12.4.5.15 SHOW FUNCTION CODE Syntax
- 12.4.5.16 SHOW FUNCTION STATUS Syntax
- 12.4.5.17 SHOW GRANTS Syntax
- 12.4.5.18 SHOW INDEX Syntax
- 12.4.5.19 SHOW INNODB STATUS Syntax
- 12.4.5.20 SHOW LOGS Syntax
- 12.4.5.21 SHOW MASTER STATUS Syntax
- 12.4.5.22 SHOW MUTEX STATUS Syntax
- 12.4.5.23 SHOW OPEN TABLES Syntax
- 12.4.5.24 SHOW PRIVILEGES Syntax
- 12.4.5.25 SHOW PROCEDURE CODE Syntax
- 12.4.5.26 SHOW PROCEDURE STATUS Syntax
- 12.4.5.27 SHOW PROCESSLIST Syntax
- 12.4.5.28 SHOW PROFILE Syntax
- 12.4.5.29 SHOW PROFILES Syntax
- 12.4.5.30 SHOW SLAVE HOSTS Syntax
- 12.4.5.31 SHOW SLAVE STATUS Syntax
- 12.4.5.32 SHOW STATUS Syntax
- 12.4.5.33 SHOW TABLE STATUS Syntax
- 12.4.5.34 SHOW TABLES Syntax
- 12.4.5.35 SHOW TRIGGERS Syntax
- 12.4.5.36 SHOW VARIABLES Syntax
- 12.4.5.37 SHOW WARNINGS Syntax
SHOW {INDEX | INDEXES | KEYS}
{FROM | IN} tbl_name
[{FROM | IN} db_name]
SHOW INDEX returns table index
information. The format resembles that of the
SQLStatistics call in ODBC.
SHOW INDEX returns the following
fields:
-
TableThe name of the table.
-
Non_unique0 if the index cannot contain duplicates, 1 if it can.
-
Key_nameThe name of the index.
-
Seq_in_indexThe column sequence number in the index, starting with 1.
-
Column_nameThe column name.
-
How the column is sorted in the index. In MySQL, this can have values “
A” (Ascending) orNULL(Not sorted). -
An estimate of the number of unique values in the index. This is updated by running
ANALYZE TABLEor myisamchk -a.Cardinalityis counted based on statistics stored as integers, so the value is not necessarily exact even for small tables. The higher the cardinality, the greater the chance that MySQL uses the index when doing joins. -
Sub_partThe number of indexed characters if the column is only partly indexed,
NULLif the entire column is indexed. -
PackedIndicates how the key is packed.
NULLif it is not. -
NullContains
YESif the column may containNULLvalues and''if not. -
Index_typeThe index method used (
BTREE,FULLTEXT,HASH,RTREE). -
CommentVarious remarks.
The LIKE clause, if present,
indicates which event names to match. The
WHERE clause can be given to select rows
using more general conditions, as discussed in
Section 19.19, “Extensions to SHOW Statements”.
You can use
db_name.tbl_name
as an alternative to the
tbl_name FROM
db_name
SHOW INDEX FROM mytable FROM mydb; SHOW INDEX FROM mydb.mytable;
You can also list a table's indexes with the mysqlshow
-k db_name
tbl_name command.
User Comments
This comment applies to http://dev.mysql.com/doc/refman/5.0/en/show-index.html
The mention of the LIKE keyword has been removed from http://dev.mysql.com/doc/refman/5.1/en/show-index.html. It is probably not a valid keyword for SHOW INDEXES.
Add your own comment.