CODE EXAMPLE FOR SQL

change filed order in mysql

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