mysql change position of column 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;