Answers for "alter table add unique constraint 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

how to add unique key constraint in mysql

-- Add a Unique constraint and deifine the constraint name
ALTER TABLE TABLENAME
ADD	CONSTRAINT UQ_tblPerson_Email UNIQUE(COLUMN_NAME)

Posted by: Guest on August-16-2021

Code answers related to "alter table add unique constraint mysql"