To rearrange columns in MySQL you can use the following snippet.
ALTER TABLE TABLENAME MODIFY COLUMN COLUMNNAME TYPE AFTER COLUMNNAME
To rearrange columns in MySQL you can use the following snippet.
ALTER TABLE TABLENAME MODIFY COLUMN COLUMNNAME TYPE AFTER COLUMNNAME