In MySQL Workbench, insert a new column at the "top" of a table?

Question

I must keep a table's columns as specified in a specification that changes quite often.

In MySQL Workbench, adding a new columns after all the others is easy, but I can't find a way to insert a new column where I want.
It is a problem, because I want to keep the columns ordered just like in the specification.

So I do it the painful way:

1. Create the new column at the bottom
2. Repeat Right-click-"Move up" tens of times to crawl my way up to the desired position

I am sure there is a more efficient way to achieve this, with the GUI rather than writing SQL code?
Even a shortcut to avoid the right-click would save me a lot of time.

Answer 1

OK, I have found! It is so easy I am ashamed I didn't find earlier...

Plain old drag and drop.

Just add the column at the bottom, then move it with your mouse to the position you want.

Answer 2

I can say that sorting with dragging doesn't work un MySQLWorkbench 6.2 on Mac.

I found a workaround, cut the columns previous to the ones you want to move and paste them after.

Answer 3

ALTER TABLE `onlineau_pharmacy`.`users` 
CHANGE COLUMN `status` `status` INT(1)  NULL DEFAULT NULL AFTER `mobile_number`;

Answer 4

If you want to insert it at the first position:

ALTER TABLE `schame_name`.`table_name` 

ADD COLUMN `column_name` FIRST;