>From: Mr. Shawn H. Corey [mailto:shawnhcorey@stripped]
>Sent: Wednesday, July 30, 2008 4:06 PM
>To: Jerry Schwartz
>Subject: Re: Re-arranging fields
>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
>> without losing their data? The best I could come up with was to copy
>> table, empty it, and then do an INSERT . SELECT specifying the new
>> 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.
[JS] Yes, this is cosmetic. Unlike the other fields, these particular ones
are only used in certain circumstances so I wanted them grouped in a
sequence that would make sense to a person.
>Just my 0.00000002 million dollars worth,
>"Where there's duct tape, there's hope."
>"Perl is the duct tape of the Internet."
> Hassan Schroeder, Sun's first webmaster