On Wed, Aug 20, 2003 at 11:16:18 -0400,
Jodi Kanter <jkanter@virginia.edu> wrote:
> Ok. so for now I want to return to where I started. so I renamed the
> table and regenerated my original table with the fields in the order
> that I like. I cannot just do a
> insert into table select * from other_table;
> because the fields are in a different order.
> Can I do this by listing the fields in my insert in the order in which I
> want them placed?
Yes. Instead of using '*' list the columns from the table that currently
has the data in the order that they appear in the table that is currently
empty.