DELETE all where MySQL foreign key constraint does not fail?
Use ignore: DELETE IGNORE ... dev.mysql.com/doc/refman/5.0/en/delete.html.
The thing is, the foreign key constraint is failing for only 1 or 2 of my 100 records I wish to delete. I wish to write a query which deletes these 98-99 records, skipping the 1 or 2 which failed, which I can later manually inspect and delete/modify. Not stopping because of some single problematic record, but continuing with the others, ignoring that.
Is there a neat way to do this?
I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.
Related Questions
DELETE all where MySQL foreign key constraint does not fail
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails?
MySQL Help Can't delete row (errno: 150) foreign key constraint?
MySQL (InnoDB): need to delete column, and accompanying foreign key constraint and index?
MySQL, foreign key constraint does not make any difference?
SQL: Can I write a CHECK constraint that validates data in a foreign table using a foreign key?