ALTER TABLE `table_name` CHANGE `old_col_name` `new_col_name` `col_data_type`;