Thiago Thiago - 5 months ago 16
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

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;
Comments