Bug #55739 Insert column {above|below} for Alter Table
Submitted: 4 Aug 2010 10:44 Modified: 4 Aug 2010 12:10
Reporter: Bruce Pieterse Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[4 Aug 2010 10:44] Bruce Pieterse
Description:
Under "Columns", the default way of making a new column is to append it to the bottom. By right-clicking on an active column you can insert a new column before or after the selected column. 

How to repeat:
- Open an SQL Editor
- Expand a Database and Expand Tables
- Right-click on a table and select "Alter Table"
- Select the "Columns" Tab
- Right-click on a Column Name i.e. id, description etc

Suggested fix:
After the above steps have been completed, in the context menu a new entry, or possibly two new, entries will be shown:

Option 1
- "Insert column" = which inserts a column below the selected column

Option 2
- Insert column above = inserts a column above the selected column
- Insert column below = inserts a column below the selected column
[4 Aug 2010 10:50] Susanne Ebrecht
Right click onto the table
=> Alter table
=> Tab columns
=> mouse pointer on the icon left from the column name
=> press left mouse button
=> move the mouse up/down by holding the button pressed
=> place column between the two columns you want to place the column
=> release mouse button

Is that what you are looking for?
[4 Aug 2010 11:11] Bruce Pieterse
Hi Susanne,

What you are asking me is column arrangement. What I'm requesting is the ability to create new columns based on the cursor selection of the user. :)

Essentially when you want to create a new column for the table you have to click on a blank column below the last column entry which automatically puts in "{TableName}col" with a Datatype of VARCHAR(45). If you read the above, the goal is to be able to do what I have just described but before or after a selected column.

I hope this helps.
[4 Aug 2010 12:10] Susanne Ebrecht
Many thanks for your feedback.

Now I understood what you meant.