On Wed, 2008-07-30 at 14:42 -0400, 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.
According to RDB theory, the order of the columns is immaterially, just as is the order of the rows. You should always explicitly name the columns in the order you want. Relying on their default order can lead to problems down the road. -- Just my 0.00000002 million dollars worth, Shawn "Where there's duct tape, there's hope." "Perl is the duct tape of the Internet." Hassan Schroeder, Sun's first webmaster -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]