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

Question

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.

Answer 1

http://dev.mysql.com/doc/refman/5.1/en/alter-table.html

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

Answer 2

You use the alter table method.

ALTER TABLE table CHANGE columnname VARCHAR(255)

Answer 3

simplest way? do you use Mysql GUI tools

Its easier from there i guess