how to reorder mysql table columns

To change the column order

ALTER TABLE table_name MODIFY COLUMN misplaced_column INT(11) AFTER other_column;