mysql>
SHOW INDEX FROM [FROM ]
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>