Posted on 2010-09-21
I am trying to delete a record from a MySQL parent table that has five foreign keys using workbench. When I use the statement DELETE FROM table WHERE id = 24 I get this error - Error Code: 1451
Cannot delete or update a parent row: a foreign key constraint fails. I am hoping that the delete from the parent table will remove the child table records as well. Any insights?