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 a
> 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 act
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 re
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 re
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
