View Single Post
Old 09-15-2009, 10:16 AM  
Pics Traffic
Confirmed User
 
Pics Traffic's Avatar
 
Industry Role:
Join Date: Jun 2004
Location: Europe
Posts: 3,055
Quote:
Originally Posted by GrouchyAdmin View Post
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.
Pics Traffic is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote