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`); 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
Post a Comment