>-----Original Message----- >From: Mr. Shawn H. Corey [mailto:[EMAIL PROTECTED] >Sent: Wednesday, July 30, 2008 4:06 PM >To: Jerry Schwartz >Cc: mysql@lists.mysql.com >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 >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. > > [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, > 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]