unique in mysql query code example

Example: mysql alter table set column unique

ALTER TABLE contacts
ADD CONSTRAINT contacts_unique UNIQUE (reference_number);