Something like ALTER TABLE [TABLE] MODIFY [COLUMN] col_name column_definition [FIRST | AFTER col_name] shoudl work
http://dev.mysql.com/doc/refman/5.0/en/alter-table.html On Wed, Jul 30, 2008 at 11:42 AM, Jerry Schwartz <[EMAIL PROTECTED]> 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. > > > > > > > > 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 > > -- Rob Wultsch [EMAIL PROTECTED] wultsch (aim) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
