MySql - Indexes

 

Working with indexes

Creating an index with the specified name on a table:

CREATE INDEX index_name
ON table_name (column,...);
Code language: SQL (Structured Query Language) (sql)

Drop an index:

DROP INDEX index_name;
Code language: SQL (Structured Query Language) (sql)

Create a unique index:

CREATE UNIQUE INDEX index_name 
ON table_name (column,...);