Sorry - then I don't really know a syntactically shorter way
On 10/17/07, Rich Rattanni <[EMAIL PROTECTED]> wrote:
>
> 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
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.
>
> INSERT
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, curr
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 illus
4 matches
Mail list logo