create mysql index

mysql create index on table   CREATE INDEX Syntax Creates an index on a table. Duplicate values are allowed: CREATE INDEX index_name ON table_name (column1, column2, …); CREATE UNIQUE INDEX Syntax Creates a unique index on a table. Duplicate values are not allowed: CREATE UNIQUE INDEX index_name ON table_name (column1, column2, …); Note: The syntax for creating indexes varies among different databases. Therefore: Check the syntax for … Read more