Handling Cascading Deletion: Are there ways to do this automatically in mySQL

Question

Hi folks,

I work with an OO database abstraction layer that I wrote. I have parameters you can set for cleaning up child records when the parent is deleted.

I was wondering if there are other, better ways to do this? Can you do this in mySQL via a stored procedure or other method?

Thanks for any advice.

JG

Answer 1

This is what foreign keys can do for you but in MySQL you have to use the innoDB engine and you have to be sure nobody will ever turn off the foreign key check.