How to rearrange columns in MySQL

To rearrange columns in MySQL you can use the following snippet.

ALTER TABLE TABLENAME MODIFY COLUMN COLUMNNAME TYPE AFTER COLUMNNAME

Please Share us:
Please rate this snippet

2 thoughts on “How to rearrange columns in MySQL

Leave a Reply