It's a relational database, field column position does not matter. One 
Date's 121 rules, if I remember correctly.

In terms of human readability, it sometimes matters. Check the MySQL 
manual, I think there's an example of this under the ALTER TABLE command.

But really, position doesn't matter, exept to fulfill a human sense of 

Cheers - Miles Thompson

At 01:53 PM 11/30/2001 +0100, Tom Churm wrote:
>i've created a mysql table from an excel csv dump and the field-order is
>not the way i want it.  could someone possibly give me a hint on how i
>can create a copy of an entire column, place it in the position where i
>want in my table, and then delete the original column?
>i'm using phpMyAdmin and there doesn't appear to be any way to
>restructure my table--so i've gotta resort to sql.
>mucho gracias,
>PHP General Mailing List (
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]

PHP General Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to