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.