Thiago Thiago - 1 year ago 105
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;
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download