How to move a column in MySQL
Move a column after some other column
mysql> ALTER TABLE mytable MODIFY COLUMN mycolumn INT AFTER someothercolumn;
Move a column to the first position
mysql> ALTER TABLE mytable MODIFY COLUMN mycolumn INT FIRST;
Categories: MySQL
Thanks a lot for this. Exactly what I needed.