how to change the order of fields in mysql code example

Example: change filed order in mysql

ALTER TABLE Employees CHANGE COLUMN empName empName VARCHAR(50) AFTER department;