How to create an index in MySQL

1 year ago

Ava Mitchell

1 minute

In MySQL, you can use the CREATE INDEX statement to create an index. The syntax is as follows:

CREATE INDEX index_name
ON table_name (column1, column2, ...);

In this case, index_name is the name of the index, table_name is the name of the table to create the index, and column1, column2, … are the names of the columns to create the index. Multiple columns can be specified to create a compound index.

For example, to create an index named “username” on a table called “users”, you can use the following statement:

CREATE INDEX idx_username
ON users (username);

Before creating an index, it is important to carefully consider which columns need an index, and choose the appropriate type and length to avoid unnecessary burden on the database.