MySQL - Working with Indexes

 

Working with indexes

Creating an index with the specified name on a table:

CREATE INDEX <indexname> ON <tablename> (column,...);
Code language: SQL (Structured Query Language) (sql)

Drop an index:

DROP INDEX <indexname>;
Code language: SQL (Structured Query Language) (sql)

Create a unique index:

CREATE UNIQUE INDEX <indexname> ON <tablename> (column,...);