The SHOW INDEX statement : Show « Command MySQL « SQL / MySQL

1. SQL / MySQL
2. Command MySQL
3. Show

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>

   
    
    
    
    
    
    
  

Related examples in the same category