List:General Discussion« Previous MessageNext Message »
From:Rob Wultsch Date:July 30 2008 7:56pm
Subject:Re: Re-arranging fields
View as plain text  
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)
Thread
Re-arranging fieldsJerry Schwartz30 Jul
  • Re: Re-arranging fieldsRanjeet Walunj30 Jul
    • RE: Re-arranging fieldsJerry Schwartz31 Jul
      • RE: Re-arranging fieldsMr. Shawn H. Corey31 Jul
        • RE: Re-arranging fieldsJerry Schwartz31 Jul
          • RE: Re-arranging fieldsMr. Shawn H. Corey31 Jul
            • RE: Re-arranging fieldsJerry Schwartz31 Jul
  • Re: Re-arranging fieldsRob Wultsch30 Jul
    • Re: Re-arranging fieldsRob Wultsch31 Jul
    • RE: Re-arranging fieldsJerry Schwartz31 Jul
  • Re: Re-arranging fieldsMr. Shawn H. Corey30 Jul
    • RE: Re-arranging fieldsJerry Schwartz31 Jul
  • Re: Re-arranging fieldsMartijn Tonies31 Jul
    • RE: Re-arranging fieldsJerry Schwartz31 Jul