Answers for "add unique contraints to colum mysql"

SQL
3

how to add unique constraint in mysql table

ALTER TABLE mytbl ADD UNIQUE (columnName);
Posted by: Guest on March-06-2020
0

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 "SQL"

Browse Popular Code Answers by Language