Create MySQL Indexes: Essential Guide

1 year ago
Benjamin Taylor
1 minute

There are two ways to create indexes in MySQL.

  1. Specify an index when creating a table: You can use the CREATE INDEX or PRIMARY KEY keywords in the CREATE TABLE statement. For example, CREATE INDEX idx_name ON table_name(column_name); CREATE TABLE table_name (column_name data_type primary key);
  2. To add an index later on, use the ALTER TABLE statement. For instance, you can add an index by using ALTER TABLE table_name ADD INDEX idx_name (column_name), or add a primary key by using ALTER TABLE table_name ADD PRIMARY KEY (column_name).
bannerAds