Display/view indexes in MySQL database

To view the index, the syntax is as follows -

select *from information_schema.statistics where table_schema= yourDatabaseName;

Here, I am using database "web". The query to show/view the index is as follows -

select *from information_schema.statistics where table_schema= 'web';

This will produce the following output. All tables in the "Web" database that contain index information are visible -

The above is the detailed content of Display/view indexes in MySQL database. For more information, please follow other related articles on the PHP Chinese website!