Re: Re-arranging fields

[Mr. Shawn H. Corey]

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