Thiago Thiago - 1 year ago 78
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?


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;