Hi
Check out the syntax for Alter Table in the on-line docs
At 10:41 15/01/2001 +0100, Carsten H. Pedersen 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?
>
>http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_14_0
>
>/ Carsten
>--------
>Carsten H. Pedersen
>Keeper and maintainer of the bitbybit.dk MySQL FAQ
>http://www.bitbybit.dk/mysqlfaq
>
>
>
>---------------------------------------------------------------------
>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
Regards
John
MySQL Development Team
__ ___ ____ __ __
/ |/ /_ __/ __/ __ \/ / John Dean <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\____/ Mansfield, England, UK
<___/
---------------------------------------------------------------------
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