How to delete a record when two tables have foreign key referenced to each other?

Question

Delete any record of them will report an error like this:

ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails

How to overcome this problem?

Answer 1

Pick a record which allows nulls to be inserted in a FK column, insert it there, delete other record and then delete the first one.