Mega Code Archive

 

Categories / MySQL / Command Mysql

 

The SHOW INDEX statement

mysql> SHOW INDEX FROM <table name> [FROM <database name>] mysql> mysql> SHOW INDEX FROM user FROM mysql; +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+----- -------+---------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Inde x_type | Comment | +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+----- -------+---------+ | user  |          0 | PRIMARY  |            1 | Host        | A         |        NULL |     NULL | NULL   |      | BTRE E      |         | | user  |          0 | PRIMARY  |            2 | User        | A         |           3 |     NULL | NULL   |      | BTRE E      |         | +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+----- -------+---------+ 2 rows in set (0.00 sec) mysql>