Another question to MySQL gurus. - GoFuckYourself.com

Pics Traffic · 09-15-2009, 09:52 AM

So I have a DB that that has 10 tables. Those tables already have some entries in them. I also have sql file that I would like to import in to existing DB and add records from import file but only those that dont exist yet. Basicly some sort of "where not exists" because right now DB has only 400 decords (in main table with primary key "ID").
Both DB and dump file with entries have identical structure. Basicly all records from 401 and up. I hope that makes sense.

Pics Traffic · 09-15-2009, 09:57 AM

Looks like INSERT IGNORE INTO is doing it ..

GrouchyAdmin · 09-15-2009, 10:13 AM

If the IDs match you could be really lazy and just set (if not already) that record as a unique key, then undo the damage after the import.

If you just want to ignore duplicates, INSERT IGNORE is likely what you need.

Pics Traffic · 09-15-2009, 10:16 AM

Quote:

Originally Posted by GrouchyAdmin

If the IDs match you could be really lazy and just set (if not already) that record as a unique key, then undo the damage after the import.

If you just want to ignore duplicates, INSERT IGNORE is likely what you need.

yes, insert ignore did it. Totaly forgot about it.

09-15-2009, 09:52 AM	#1
Pics Traffic Confirmed User Industry Role: Join Date: Jun 2004 Location: Europe Posts: 3,055	Another question to MySQL gurus. So I have a DB that that has 10 tables. Those tables already have some entries in them. I also have sql file that I would like to import in to existing DB and add records from import file but only those that dont exist yet. Basicly some sort of "where not exists" because right now DB has only 400 decords (in main table with primary key "ID"). Both DB and dump file with entries have identical structure. Basicly all records from 401 and up. I hope that makes sense.

09-15-2009, 10:13 AM	#3
GrouchyAdmin Now choke yourself! Industry Role: Join Date: Apr 2006 Posts: 12,085	If the IDs match you could be really lazy and just set (if not already) that record as a unique key, then undo the damage after the import. If you just want to ignore duplicates, INSERT IGNORE is likely what you need. __________________ AIM: GrouchyGfy

09-15-2009, 09:57 AM	#2
Pics Traffic Confirmed User Industry Role: Join Date: Jun 2004 Location: Europe Posts: 3,055	Looks like INSERT IGNORE INTO is doing it ..