Categories
mysql

How to rearrange MySQL columns?

I need to move the position of existing columns (for better visibility).

How can this be done without affecting the data?

Modify also works. Have a look:

ALTER TABLE foo MODIFY bar bartype AFTER baz;