SQL

create table with index mysql

CREATE TABLE emp_details (
id INT,
full_name VARCHAR(50),
email VARCHAR(50),
mobile INT NOT NULL,
PRIMARY KEY (id),
INDEX (id, email)
);

mysql create table index

## Adding an Index to Existing Table
CREATE INDEX indexName ON tableName (ID, LName, FName, LOC);

## Adding an Index to Existing Table with Primary Key
CREATE UNIQUE INDEX indexName ON tableName (ID, LName, FName, LOC);