Answers for "mysql alter table add unique key"

mysql set field unique

ALTER TABLE mytbl ADD UNIQUE (columnName);

Posted by: Guest on March-06-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 "mysql alter table add unique key"