MySql - Indexes

  Working with indexes Creating an index  with the specified name on a table: CREATE INDEX index_name ON table_name ( column ,...); Code ...

 

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,...);