MySQL Crash Course

CREATE INDEX

CREATE INDEX is used to create an index on one or more columns. See Chapter 21 for more information.

• Input

CREATE INDEX indexname ON tablename (column [ASC|DESC], ...);