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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.051 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.