Answers for "add a unique contraint field to a table with data mysql"

how to add unique constraint in mysql table

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 "add a unique contraint field to a table with data mysql"