Mysql Create and Show indexes

To create an index you need to run a sql query looking like this :

CREATE INDEX index_name
ON table_name (column1, column2, ...);

You can specify more than one column to index.

 

For example, you can create an index called user_city based on the table users and on the column city.

The query should look like this.

CREATE INDEX user_city
ON users (city);

 

If you need to check the indexes on a table in your database use this command:

SHOW INDEXES FROM table_name;

 

You can specify the database where you would like to check indexes using this command:

SHOW INDEXES FROM table_name 
IN database_name;

Or this

SHOW INDEXES FROM database_name.table_name;