MySQL Bugs: #6485: Reordering of fields in Edit Table not possible

Bug #6485	Reordering of fields in Edit Table not possible
Submitted:	7 Nov 2004 18:57	Modified:	17 Feb 2009 12:25
Reporter:	[ name withheld ]	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S4 (Feature request)
Version:	1.1.0 Gamma	OS:	Windows (Windows XP Pro SP2)
Assigned to:		CPU Architecture:	Any

Description:
When creating or editing a table, reordering of table fields does not seem to be supported as dragging the fields around (even though it shows a placement indicator) doesn't do anything. This is a huge PIA to work around with manual ALTER TABLE statements.

How to repeat:
Edit an existing table and try and drag the fields around (up and down) to reposition them, the operation is not supported when you "drop" the field in its new location.

Suggested fix:
Please finish the implementation of this OR atleast provide a right-click > "Insert field here" operation like MySQL CC had to work around this... but DND would be much better.

Many thanks for writing a bug report.

It is not SQL Standard conform to resort column order.

Because it is possible at MySQL Workbench we won't fix it here.

Bug #36236 is a duplicate of this bug here.

Bug #25784 is set as duplicate of this bug here

Bug #16909 was set as duplicate of this bug here.

Bug #9043 is a duplicate of this bug here

Bug #12653 was set as duplicate of this bug here.

Bug #14608 was set as duplicate of this bug here.

Please fix this problem.  I realize that it might not be easy, and that there might be other round-about ways of accomplishing the same thing in other programs, but we are all trying to create a great, easy-to-use database program that is as good or better than Micro$oft Access.  Fixing a routine inconvenience like this could do wonders to first impressions of the software and help keep word-of mouth advetizing positive and prosperous.

Look at all of the bug reports that have been filled in for this issue.  It's obviously something that the people want.  Let's give it to them! :)

Many thanks for writing a feature request. We are on the way to implement MySQL Query Browser into MySQL Workbench and won't add this feature anymore.

"won't add this feature?" Why won't you add this feature?

For those of you who want to add a column where YOU want, and just want to get the job done without hearing from a moderator that your request is invalid, do this in MySQL Query Browser:

Edit the table, and add the column to the end, click "apply changes" and then a "confirm table edit" window will pop up. Select the text in the window, press ctrl-C to copy it, then cancel the window, then discard the changes in the table editor. Then simply paste the SQL into the SQL Query Area and change the AFTER field to whatever you want. Easy as mud pie.

Duplicate of: Bugs #6485 #9043 #12064 #12653 #14608 #16909 #25784 #36236