In article <3daff3bf_2(at)goliath2(dot)newsgroups(dot)com>, Paul wrote:
> Hi,
>
> How can I select data from table into an existing table. I've redesigned
> some tables and thus want my data to be copied from the old table to the new
> one. Since the column order, names (and the number of columns) is not equal
> i thought of using:
>
> select column1,column2 into newtable from oldtable
>
> THis however leads to an error that states that the table exists already.
> Deleting the table is no option for me since I want the data to be in the
> table with the new structure.
>
INSERT INTO newtable (SELECT column1, column2 FROM oldtable);