Bug #5713 Possibility to change order of fields
Submitted: 23 Sep 2004 9:09 Modified: 10 Sep 2007 10:32
Reporter: Sebastiaan Lubbers Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQLCC Severity:S4 (Feature request)
Version:0.9.4 beta OS:Windows (Windows 2000)
Assigned to: CPU Architecture:Any

[23 Sep 2004 9:09] Sebastiaan Lubbers 
Description:
It is not possible to change the order of the table fields (e.g.

(FIELD 1) language_name
(FIELD 2) language_id

to

(FIELD 1) language_id
(FIELD 2) language_name

How to repeat:
!

Suggested fix:
!
[26 Jul 2007 7:30] Andrei Kravtsov 
If you want to change fields order, do this:

1. Export your table in sql format
2. Drop the table from database
3. Create it again with new fields order
4. In exported file remove everything except INSERT INTO fields
5. Import modified file back to database.
6. Should work
[10 Sep 2007 10:32] Valeriy Kravchuk 
Thank you for your interest in the MySQL graphical administration tools. We recommend that you use our MySQL Administrator and MySQL Query Browser.  The MySQLGUI and MySQL Command Center legacy products are deprecated, and we are no longer maintaining those projects.

For more information on MySQL Administrator, see:
http://www.mysql.com/products/administrator/