Re: MySQL: copying entire columns

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: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net