how to make a field unique in database code example

Example: mysql set field unique

ALTER TABLE mytbl ADD UNIQUE (columnName);