CODE EXAMPLE FOR SQL

how to add an index to an existing table (mysql)

## 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);