I am not changing the ordering, but i do not want to copy the primary
key field since it is auto increment (I neglected too mention that
before, sorry).
On 10/16/07, Vitali Lovich <[EMAIL PROTECTED]> wrote:
> Well, you don't have to list the columns if you're not changing the
> ordering.
>
>
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,
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
3 matches
Mail list logo