I get the following error when I try to delete a record in the user table that has an entry in the feedback table:
e.g. when a record in the feedback table has a reference to the user table
1451 - Cannot delete or update a parent row: a foreign key constraint fails (
fk_feedback_user1FOREIGN KEY (
user_id) ON DELETE NO ACTION ON UPDATE NO ACTION)
The relationship between the two tables:
I hope someone could help me into the right direction and that my question is clear enough. I've followed a database design course but forgot a lot of stuff.