You can specify field order with the LOAD DATA
command...then you'll never have to worry about the
order of the table columns.
LOAD DATA INFILE 'x' INTO table (field3,field1,field2)
double check the LOAD DATA syntax in the manual.
Brian
--- Marcus Ouimet <[EMAIL PROTECTED]> wrote:
> OK, I am really stuck sorry to have to post this. I
> have searched through the documentation and maybe I
> am just searching with the wrong words on the MySQL
> site. I am wanting to reorder the fields I have in a
> table - not the data in the fields (I have lots of
> info on this) but the actual fields themseleves I
> want to reorder. Ie instead of the fields listed in
> a Table like:
>
> field1
> field2
> field3
>
> I want to move the fields to be:
>
> field3
> field1
> field2
>
> This is only because I am importing a flatline
> database and want to move things around? Can this be
> done?
>
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
