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*
Asked
Active
Viewed 2,706 times
1
David542
- 101,766
- 154
- 423
- 727
-
1Could 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
-
1`insert ignore` works. – pala_ May 13 '15 at 23:31
1 Answers
3
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.
pala_
- 8,723
- 1
- 14
- 32
-
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