why use unique constraint in mysql code example

Example 1: mysql remove unique constraint

ALTER TABLE tbl_name DROP INDEX index_name

Example 2: mysql alter table set column unique

ALTER TABLE contacts
ADD CONSTRAINT contacts_unique UNIQUE (reference_number);