IGNORE

The IGNORE option tells the server to ignore some common errors.

IGNORE can be used with the following statements:

• DELETE

• INSERT (see also INSERT IGNORE)

The logic used:

• Variables out of ranges are replaced with the maximum/minimum value.

• STRICT_TRANS_TABLES, STRICT_ALL_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE are ignored.

• Inserting NULL in a

The following errors are ignored:

Ignored errors normally generate a warning.

A property of the IGNORE clause consists in causing transactional engines and non-transactional engines (like InnoDB and Aria) to behave the same way. For example, normally a multi-row insert which tries to violate a UNIQUE contraint is completely rolled back on InnoDB, but might be partially executed on Aria. With the IGNORE clause, the statement will be partially executed in both engines.

Duplicate key errors also generate warnings. The server variable can be used to prevent this.

_{This page is licensed: CC BY-SA / Gnu FDL}