In 5.7.5, as a part of the larger effort to improve error handling, we re-implemented the IGNORE clause (WL#6614). The IGNORE clause is a MySQL extension to the SQL standard. It affects the errors which occur for each row. The new implementation aims to make the behavior of the IGNORE clause more consistent.
Statements which support the IGNORE clause are:
- INSERT [ IGNORE ]
- UPDATE [ IGNORE ]
- DELETE [ IGNORE ]
- LOAD DATA [ IGNORE ]
- LOAD XML [ IGNORE ]
- CREATE TABLE… [ IGNORE ] SELECT
When the INSERT statement is used to insert a number of rows into a table, an exception during processing would normally abort the statement and return an error message. With the IGNORE keyword, rows that cause certain exceptions are ignored, but the remaining rows are inserted and the …
[Read more]