alter table change order varchar code example

Example: change filed order in mysql

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