change mysql table column from ENUM to VARCHAR

 

 

mysql> ALTER TABLE database.table MODIFY column-name varchar(255) default ’10M’;

 
Query OK, 12137 rows affected (1.40 sec)
Records: 12137 Duplicates: 0 Warnings: 0