mysql move field up code example
Example 1: how to move a columns location in mysql
ALTER TABLE table_name MODIFY password varchar(20) AFTER id
Example 2: how to move a column to different spot mysql
ALTER TABLE TableEx MODIFY COLUMN colName VARCHAR(50) AFTER colName2;