GoFuckYourself.com - Adult Webmaster Forum - View Single Post - Any SQL gurus in the house? Can you help?

Phil · 09-24-2008, 03:44 PM

I have two identical structure DBs. One has 1000+ records (DB1) the other one that has 200 (DB2). I would like to combine those two by adding 1000 records to smaller DB skipping duplicates (based on primary key - ID).. so basically moving 800 records starting with ID=201 from DB1 to DB2

09-24-2008, 03:44 PM
Phil Confirmed User Join Date: Jan 2004 Posts: 7,659	Any SQL gurus in the house? Can you help? I have two identical structure DBs. One has 1000+ records (DB1) the other one that has 200 (DB2). I would like to combine those two by adding 1000 records to smaller DB skipping duplicates (based on primary key - ID).. so basically moving 800 records starting with ID=201 from DB1 to DB2 __________________ Ask Phil