Jerry Schwartz wrote:
Is there any reasonable way of re-arranging the order of columns in a table
without losing their data? The best I could come up with was to copy the
table, empty it, and then do an INSERT . SELECT specifying the new order of
the fields.
This can also be achieved in following manner.
a) Rename table to tablename_new
b) create table Tablename (fieldnames and datatypes) Select
field1,field2...fieldn from tablename_new;
But why do you want to do it in first place ?
Regards,
Ranjeet Walunj
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
