Thiago Thiago - 1 year ago 92
SQL Question

Modify atribute type in MySQL

How can I modify the type (or domain) of a column (or atribute) in MySQL using alter table command?

Answer Source

You can use alter table .. could you must delete the data in some case (you can copy and the update)

 alter table your_table modify your_column  your_data_type;