Answers for "mysql how to add a unique column to a table"

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

Code answers related to "mysql how to add a unique column to a table"