Re: Moving Fields Around

2001-01-15 Thread Carsten H. Pedersen
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

Re: Moving Fields Around

2001-01-15 Thread John Dean
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

Moving Fields Around

2001-01-14 Thread Marcus Ouimet
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

Re: Moving Fields Around

2001-01-14 Thread Brian Kaney
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