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

Question

I need to change the data type of multiple columns from float to int.

How can I do it?

Also, there is no data to be worried about, yet.

Answer 1

ALTER TABLE tablename MODIFY columnname INTEGER;

This will be changing the datatype of a given column

Based on how many columns you need to change, it might be the best to generate a script or use any sort of the MySQL client GUI 

Are you Interested to Learn SQL? Choose this SQL Certification course for learning more about SQL.