How to create add indexes to MySQL tables
Advertisement
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 10 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 10 years ago
- Sunny Solu


Your Answer