MySQL Lists: mysql: Re-arranging fields

List:	General Discussion	« Previous Message Next Message »
From:	Jerry Schwartz	Date:	July 30 2008 6:42pm
Subject:	Re-arranging fields
View as plain text

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.

 

 

 

Regards,

 

Jerry Schwartz

The Infoshop by Global Information Incorporated

195 Farmington Ave.

Farmington, CT 06032

 

860.674.8796 / FAX: 860.674.8341

 

 <http://www.the-infoshop.com> www.the-infoshop.com

 <http://www.giiexpress.com> www.giiexpress.com

www.etudes-marche.com

Thread
• Re-arranging fields	Jerry Schwartz	30 Jul
• Re: Re-arranging fields	Ranjeet Walunj	30 Jul
• RE: Re-arranging fields	Jerry Schwartz	31 Jul
• RE: Re-arranging fields	Mr. Shawn H. Corey	31 Jul
• RE: Re-arranging fields	Jerry Schwartz	31 Jul
• RE: Re-arranging fields	Mr. Shawn H. Corey	31 Jul
• RE: Re-arranging fields	Jerry Schwartz	31 Jul
• Re: Re-arranging fields	Rob Wultsch	30 Jul
• Re: Re-arranging fields	Rob Wultsch	31 Jul
• RE: Re-arranging fields	Jerry Schwartz	31 Jul
• Re: Re-arranging fields	Mr. Shawn H. Corey	30 Jul
• RE: Re-arranging fields	Jerry Schwartz	31 Jul
• Re: Re-arranging fields	Martijn Tonies	31 Jul
• RE: Re-arranging fields	Jerry Schwartz	31 Jul