mysql add index alter table code example

Example: how to create index mysql

# index_name will identify your index for future reference
CREATE INDEX index_name ON table_name (column_name);