How can I INSERT rows into a new table and update the primary key of the transported items?
Posted
by ggg
on Stack Overflow
See other posts from Stack Overflow
or by ggg
Published on 2010-04-04T14:04:22Z
Indexed on
2010/04/04
14:13 UTC
Read the original article
Hit count: 271
The new table has an auto-increment that I want to use for the data that I'm transferring.
Here is the query I want to run.
INSERT INTO `xyz_1mydata` SELECT * FROM `xyz_1production` WHERE `xyz_1production.Id` > '12000';
I don't want to replace the existing items in #_1mydata.
© Stack Overflow or respective owner