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
<jschwartz@stripped> 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
wultsch@stripped
wultsch (aim)
