Well, you don't have to list the columns if you're not changing the
ordering.
INSERT INTO table1 SELECT * FROM table2;
Rich Rattanni wrote:
I have two tables in a database with exactly the same schema
(idNum PRIMARY KEY, data1, data2)
I want to copy all the records in table 2 to table 1, currently I am
using the following statement:
INSERT INTO table1 (data1, data2) SELECT data1, data2 FROM table2.
Now this is just a simplified illustration, in my case I am copying
about 10 columns over. I was wondering if there was a compact way to
write the SQL statement, that copied the data over from one table to
the other ignoring the primary key fields. I suspect there is not,
but I figured it wouldnt hurt to ask.
--
Thanks,
Richard Rattanni
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------