Mysql Add new column (at position)?

I have been playing with the Mysql tools as to integrate my work flow. The one thing I am having trouble figuring out how to insert a new column after another column. It seems even right clicking on the column I would like to add the new column after and choosing the new column option, it still adds the column to the end of the table. I really hope I do not have to add my own "after" statement to the query every time I want to insert a column.

Any ideas?

TIA

Please sign in to leave a comment.