Bug #25784 Cannot reorder columns in MySQL Administrator
Submitted: 23 Jan 2007 15:13 Modified: 17 Sep 2008 15:33
Reporter: Adam Wood Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Administrator Severity:S4 (Feature request)
Version:1.1.9 OS:Windows (WINXP Pro SP2)
Assigned to: CPU Architecture:Any

[23 Jan 2007 15:13] Adam Wood 
Description:
When using the MySQL Table Editor to modify a table's structure/field definitions, there is no way to reorder columns, or insert new columns between existing ones. I know that this could in theory be done manually by typing out the query, but it would be much easier if this could be done using good old drag n' drop!

How to repeat:
Choose "Edit Table" from MySQL Administrator to open MySQL Table Editor and try and insert a field between existing ones.

Suggested fix:
When Table Editor is generating the data definition query to insert/modify fields, include the AFTER clause to allow it to specify a field's (new) position.
[17 Sep 2008 15:33] Susanne Ebrecht 
This is a duplicate of bug #6485
[19 Sep 2008 12:09] Susanne Ebrecht 
Sorry, this is a duplicate of bug #12064
[27 Sep 2016 1:16] David Refoua 
Duplicate of: Bugs #6485 #9043 #12064 #12653 #14608 #16909 #25784 #36236