Hey. Question by mysql. How does DELETE IGNORE ... work? I do not understand what mistakes are ignored. I read the official standard, I did not understand. Here is the link - http://dev.mysql.com/doc/refman/5.7/en/delete.html

  • I clarify - you can not understand what errors can occur when deleting database elements? - isnullxbh
  • I do not understand how this garbage works - Dimon

1 answer 1

In simple terms, IGNORE recounts certain types of errors and returns warnings instead. While without IGNORE if an error occurs, the work stops, then with IGNORE , the error is simply skipped (but a warning is displayed) and the interruption does not happen.
Ignored errors:
ER_BAD_NULL_ERROR ER_DUP_ENTRY ER_DUP_ENTRY_WITH_KEY_NAME ER_DUP_KEY ER_NO_PARTITION_FOR_GIVEN_VALUE ER_NO_PARTITION_FOR_GIVEN_VALUE_SILENT ER_NO_REFERENCED_ROW_2 ER_ROW_DOES_NOT_MATCH_GIVEN_PARTITION_SET ER_ROW_IS_REFERENCED_2 ER_SUBQUERY_NO_1_ROW ER_VIEW_CHECK_FAILED

  • ER_DUP_ENTRY ER_DUP_ENTRY_WITH_KEY_NAME ER_DUP_KEY ER_BAD_NULL_ERROR ER_NO_PARTITION_FOR_GIVEN_VALUE ER_NO_PARTITION_FOR_GIVEN_VALUE_SILENT ER_NO_REFERENCED_ROW_2 ER_ROW_DOES_NOT_MATCH_GIVEN_PARTITION_SET ER_ROW_IS_REFERENCED_2 ER_SUBQUERY_NO_1_ROW ER_VIEW_CHECK_FAILED - vental
  • Here are all types of ignored errors - Vental
  • thank. for the answer - Dimon
  • Not at all, there will be questions - please contact - Vental
  • I have from another forum, the guys suggested on this issue. I'll write now - Dimon