sql - How to implement CANDIDATE key in any MySQL table -


i want implement candidate key in sql table.

my table has columns id, city, state

how make candidate key on city , state columns.

alter table mytable add unique key `my_unique_key` (`city`, `state`); 

Comments