How do I reorder columns in MySQL Query Editor?

Question

I want to move column OtherSupport below Amount2 ... is there an easy way to do this?

Answer 1

ALTER TABLE myTable MODIFY OtherSupport VARCHAR(50) AFTER Amount2;

Answer 2

You're not the first one to ask. Here's the feature request.

Either do it using SQL or use MySQL Workbench.