I think I said that right. I am trying to adapt an existing database for use with a new script and it seems that the fields need to be in the same order for "Copy table to (database.table)" function of phpmyadmin to work properly. Or maybe I just don't know what I am doing.
You can manually copy the data and change the order column in the SELECT statement e.g. INSERT INTO new_table SELECT col1, col3, col2, col4 FROM old_table Code (markup):
Hello, Yes, using the insert/select if the easy way , you can create a script in php, like get the information for the old table and then insert it in the new table, sometime a script is useful if you want to clean information, etc etc Best regards, Jakomo
Why do you need to change the order? In any queries you can specify the order in the datatable that is returned or the order which they are inserted into the table etc.
Guys THANKS to all who replied. This was my first time doing something like this. I wound up doing a simple export/import to resolve the issue. That was what I tried first, but what I failed to do was change all the table names in the sql file before I imported it into the new table. Once I saved the sql file and used replace all to replace the table names it worked fine.