Answers for "add unique constraint mysql alter"

SQL
3

how to add unique constraint in mysql table

ALTER TABLE mytbl ADD UNIQUE (columnName);
Posted by: Guest on March-06-2020
0

mysql create unique key via alter table

ALTER TABLE Persons

ADD CONSTRAINT UC_Person UNIQUE (ID,LastName);
Posted by: Guest on May-31-2021

Code answers related to "add unique constraint mysql alter"

Code answers related to "SQL"

Browse Popular Code Answers by Language