Change unique key together in mysql
45,024
Solution 1
ALTER TABLE your_table
DROP INDEX user_id,
ADD UNIQUE KEY `user_id` (`user_id`,`account_id`,`pet_id`)
Note: You won't need the backticks around the column names if you're using mariadb on Linux - in fact it will throw an syntax error 1064/(42000)
Solution 2
Drop the first key and then create the new one.
Comments
-
yossi over 2 years
I have in my MYSQL table a unique key and i want to add to it.
UNIQUE KEY `user_id` (`user_id`,`account_id`)
and i want to add another
UNIQUE KEY `user_id` (`user_id`,`account_id`,`pet_id`)