how to remove unique from the column in mysql code example
Example 1: how to remove unique key in mysql
ALTER TABLE mytable DROP INDEX key_Name;
Example 2: how to remove unique key constraint in mysql
DROP INDEX index_name ON tbl_name
ALTER TABLE mytable DROP INDEX key_Name;
DROP INDEX index_name ON tbl_name