• support@answerspoint.com

How to create add indexes to MySQL tables

348

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 3 years ago
  • Sunny Solu

2Answer


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

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

  • answered 3 years ago
  • Sunny Solu

0
ALTER TABLE TABLE_NAME ADD INDEX (COLUMN_NAME);
  • answered 3 years ago
  • Sunny Solu

Your Answer

    Facebook Share        
       
  • asked 3 years ago
  • viewed 348 times
  • active 3 years ago

Hot Questions