MySQLism: avoid using MySQL IGNORE syntax

Last updated on

8 September 2016

Drupal 7 will no longer be supported after January 5, 2025. Learn more and find resources for Drupal 7 sites

MySQL allows the use of IGNORE in UPDATE or REPLACE queries.

INSERT IGNORE INTO
REPLACE IGNORE INTO

This syntax is not supported by any other database.
Therefore avoid it.

Help improve this page

Page status: No known problems

You can:

Log in, click Edit, and edit this page
Log in, click Discuss, update the Page status value, and suggest an improvement
Log in and create a Documentation issue with your suggestion