mysql make existing username column have to be unique code example

Example: mysql set field unique

ALTER TABLE mytbl ADD UNIQUE (columnName);