NEWBIE: Any way to ignore duplicates on INSERT?
Posted on 2006-10-31
I'm trying to insert records from one table into another table with the same key structure. I'm using:
So the entire insert takes place in a single statement.
But it fails if even a single record already exists in both tables.
Is there any way to say "If there's a duplicate, OVERWRITE the OLD with the NEW"?
If not, is there any way to say, "If there's a duplicate, ignore it"?
If not that either, what do I do? Throw myself off a bridge? How high?