[PHP] MySQL: copying entire columns

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

Re: [PHP] 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

Re: [PHP] MySQL: copying entire columns

hi, miles: i think you helped me hit on something big here. each time i've been using INSERT statements in my php code, i've been addressing the field names in exactly the order they appear in my mysql table. ie: i've been using $sql = Insert into $table_name(Name, Address, Phone)

Re: [PHP] MySQL: copying entire columns

[] = implode(,,$tmp); } $fd = fopen($out_fname,'w+'); fwrite($fd,implode(\r\n,$out_cont)); fclose($fd); ? HTH Regards, Andrey Hristov - Original Message - From: Tom Churm [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 30, 2001 2:53 PM Subject: [PHP] MySQL: copying entire