Eric Wilson Eric Wilson - 4 months ago 9
MySQL Question

How do I change the data type for a column in MySQL?

I want to change the data type of multiple columns from float to int. What is the simplest way to do this?

There is no data to worry about, yet.


ALTER TABLE tablename MODIFY columnname INTEGER;

This will change the datatype of given column

Depending on howmany columns you wish to modify it might be best to generate a script, or use some kind of mysql client GUI