Tom 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 "tidiness". Cheers - Miles Thompson At 01:53 PM 11/30/2001 +0100, Tom Churm wrote: >hi, > >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, > >tom > >-- >PHP General Mailing List (http://www.php.net/) >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 (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
