Answers for "make unique key in mysql"

mysql set field unique

ALTER TABLE mytbl ADD UNIQUE (columnName);

Posted by: Guest on March-06-2020

mysql alter table set column unique

ALTER TABLE contacts
ADD CONSTRAINT contacts_unique UNIQUE (reference_number);

Posted by: Guest on June-17-2020

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 "make unique key in mysql"