Check out example codes for "mysql alter table set column unique". It will help you in understanding the concepts better.

Code Example 1

ALTER TABLE mytbl ADD UNIQUE (columnName);

Code Example 2

ALTER TABLE contacts
ADD CONSTRAINT contacts_unique UNIQUE (reference_number);

Learn ReactJs, React Native from akashmittal.com