how to change position of existing column in mysql code example
Example 1: how to move a columns location in mysql
ALTER TABLE table_name MODIFY password varchar(20) AFTER id
Example 2: change filed order in mysql
ALTER TABLE Employees CHANGE COLUMN empName empName VARCHAR(50) AFTER department;