ON DUPLICATE update nothing

Question

I know that I can use UPDATE IGNORE to pass on whether there is a duplicate key. How would I use the following syntax to do the same?

INSERT INTO table ON DUPLICATE KEY *do nothing*

Could try adding superfluous logic akin to `ON DUPLICATE KEY 1 = 1` — Mike Purcell, May 13 '15 at 22:58
@MikePurcell Well by doing that you are doing "something". The question is to avoid doing anything. — Trevi Awater, May 13 '15 at 23:04

score 4 · Accepted Answer · answered May 14 '15 at 01:33

4

You do it the exact same way.

INSERT IGNORE INTO table ....

That will silently skip any constraint violations. For a bulk insert (eg insert ignore into table select ... from ...), this will skip the rows that violate a constraint, but continue to insert all rows that can be.

Useful for duplicate removal.

answered May 14 '15 at 01:33

pala_

8,901
1
15
32

1

Note, INSERT IGNORE also ignores other errors such as partitioning allocation errors and does not only ignore key conflicts. – Gyrien Aug 04 '20 at 18:20

ON DUPLICATE update nothing

1 Answers1