![[ MySQL INSERT IGNORE ] Insert The Record Only If It Does Not Exist](https://cdn.blogarama.com/images/posts_thumbs_site_id/12949/1294899-373369518.jpg "[ MySQL INSERT IGNORE ] Insert The Record Only If It Does Not Exist")
INSERT IGNORE option by MySQL is a very convenient keyword to gracefully handle an INSERT of a record with an existing Key.
The regular INSERT always lead to a Primary Key violation error on above condition. But with IGNORE option, the query silently ignore the insert request on existing Key insertion.
Related Articles
INSERT IGNORE INTO
book (isbn, author, name, category, year, publisher)
VALUES
(9780596009205, 'Kathy Sierra, Bert Bates', 'Head First Java', 'Technology', 2013, ' O'Reilly Media, Inc.');
1 row(s) affected
book (isbn, author, name, category, year, publisher)
VALUES
(9780596009205, 'Kathy Sierra, Bert Bates', 'Head First Java', 'Technology', 2013, ' O'Reilly Media, Inc.');
0 row(s) affected, 1 warning(s): 1062 Duplicate entry '9780596009205' for key 'PRIMARY'
https://dev.mysql.com/doc/refman/8.0/en/insert.html
