MySQL won't let me delete rows

[dkr]

Hi there,

I am trying to clean out my database by deleting entries in certain tables. However, I am constantly getting a MySQL error message saying that I can't do so.

Is there any way I can work around this?

#1451 - Cannot delete or update a parent row: a foreign key constraint fails (`rayku_db`.`shout`, CONSTRAINT `shout_ibfk_1` FOREIGN KEY (`poster_id`) REFERENCES `user` (`id`))

Thanks!

 

[Chicken]

Have you tried looking at stackoverflow? Seems to be the same problem as you.

http://stackoverflow.com/questions/...e-a-parent-row-a-foreign-key-constraint-fails

 

[eagle12]

It is because that record relates to another record. Chances are, that is tables records is the one in a one-to-many relationship. This means that you need to delete the records on the many side first. Then you can delete the record you are trying to delete.