Can I order/reorder fields in a table in MySQL? — OZONE Asylum, home of the Mad Scientists

FAQ

Can I order/reorder fields in a table in MySQL?

This page's ID: 5475

You are editing "Can I order/reorder fields in a table in MySQL?"

Who can edit an FAQ?	Anyone registered may edit an FAQ.

Your User Name:
Your Password:
Login Options:	Remember Me On This Computer

Your Text: Insert Slimies » Insert UBB Code » Close Last Tag \| All Tags UBB Help	Yes although it is not an operation for the faint-hearted (hopefully MySQL administartion code will automate this kind of operation). Basically you need to create a nother table to store the data in while you destroy the current table and then rebuild it again and put the data back in the order you want. That description makes it sound more complex than it needs to be - see the examples below for more details: -------------------------------- Relevant links: [url=http://www.geocrawler.com/mail/thread.php3?subject=Order+of+fields&list=108]Order of fields[/url] [url=http://www.ultraviolet.org/mail-archives/mysql.2001/7138.html]Moving Fields Around[/url] [url=http://www.mysql.com/doc/en/ALTER_TABLE.html]MySQL Manual: 6.5.4 ALTER TABLE Syntax[/url] - might also prove useful. [b]products[/b] [url=http://www.scibit.com/Products/Software/Utils/Mascon.htm]Mascon[/url] - seem to offer a free version which will reorder tables. [url=http://www.ems-hitech.com/mymanager/]EMS MySQL Manager[/url] - appears to be able to do this (although it isn't free). ________________________ [internallink=4626]Emperor[/internallink] [small][i](Added by: [url=http://www.ozoneasylum.com/cgi-bin/ubbmisc.cgi?action=getbio&UserName=Emperor]Emperor [/url] on Thu 12-Dec-2002)[/i][/small] Loading...
Options:	Enable Slimies Enable Linkwords

« Backwards — Onwards »

Show Forum Drop Down Menu