How can I INSERT rows into a new table and update the primary key of the transported items?
- by ggg
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.