Answers for "mysql add unique constraint while creating table"

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 "mysql add unique constraint while creating table"

Code answers related to "SQL"

Browse Popular Code Answers by Language