add index in a table using mysql code example

Example: mysql alter table add index

ALTER TABLE TABLE_NAME ADD INDEX `index_name` (`column_name`)