mysql change order of fields code example
Example: change filed order in mysql
ALTER TABLE Employees CHANGE COLUMN empName empName VARCHAR(50) AFTER department;
ALTER TABLE Employees CHANGE COLUMN empName empName VARCHAR(50) AFTER department;