mysql change column order code example
Example 1: change filed order in mysql
ALTER TABLE Employees CHANGE COLUMN empName empName VARCHAR(50) AFTER department;
Example 2: how to move a column to different spot mysql
ALTER TABLE TableEx MODIFY COLUMN colName VARCHAR(50) AFTER colName2;