DELETE IGNORE suppresses errors and downgrades them as warnings, if you are not aware how IGNORE behaves on tables with FOREIGN KEYs, you could be in for a surprise.
Let’s take a table with data as example, column c1 on table t2 references column c1 on table t1 – both columns have identical set of rows for simplicity.



Recent comments
20 weeks 2 days ago
21 weeks 6 days ago
21 weeks 6 days ago
21 weeks 6 days ago
21 weeks 6 days ago
21 weeks 6 days ago
21 weeks 6 days ago
21 weeks 6 days ago
21 weeks 6 days ago
21 weeks 6 days ago