How to create add indexes to MySQL tables

1751

I want to create and add an unique index composed with more than one field using sql command in mysl databse

ALTER TABLE `table` ADD INDEX `product_id` (`product_id`)

Never compare integer to strings in mysql. If id is int = remove the quotes.

ALTER TABLE TABLE_NAME ADD INDEX (COLUMN_NAME);

Mysql