Mysql – How to 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.

Best Solution

ALTER TABLE tablename MODIFY columnname INTEGER;

This will change the datatype of given column

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