Delete Or Update A Parent Row A Foreign Key Constraint Fails

Cannot delete or update a parent row: a foreign key constraint fails (table1.user_role, constraint fk143bf46a8dsfsfds@#5a6bd60 foreign key (user_id) references user (id))what i did in two simple steps . first i delete the child row in child table like. Hibernate throws cannot delete or update a parent row: a foreign key constraint fails. ask question. cannot delete or update a parent row: a foreign key constraint fails. can someone please help me how to test the cascade delete option here? java mysql hibernate. share | improve this question. edited feb 10 '16 at 12:58. jens. 52.1k 12 52 75.. Description: i create a database (blog) holding a number of tables one of which has a foreign key constraint to another. if i do a drop database blog; then the drop fails with a error 1217: cannot delete or update a parent row: a foreign key constraint fails ..

Error while deleting an account