Show Indexes For A Table In MySQL
When describing a table, such as users
:
We can see in the Key
column that there's a primary key and a unique key
for this table on id
and email
, respectively.
These keys are indexes. To get more details about each of the indexes on
this table, we can use the
show indexes
command.