How to create add indexes to MySQL tables

How to create add indexes to MySQL tables
I want to create and add an unique index composed with more than one field using sql command in mysl databse
Mysql
- asked 9 years ago
- Sunny Solu
2Answer
ALTER TABLE `table` ADD INDEX `product_id` (`product_id`)
Never compare integer
to strings
in mysql. If id
is int
= remove the quotes.
- answered 9 years ago
- Sunny Solu

Your Answer