update a colun as unique using query mysql code example Example: mysql set field unique ALTER TABLE mytbl ADD UNIQUE (columnName);