Check out example codes for "change filed order in mysql". It will help you in understanding the concepts better.

Code Example 1

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

Learn ReactJs, React Native from akashmittal.com