automatism to delete related records

[kurisusan]

Hello,

is there any automatism to delete related records after having deleted a 'parent' record?

Christian

[shannah]

Best way is to use the INNODB storage engine for those tables, and then use a foreign key relationship with "on delete cascade".

That way the database will always stay consistent.

The alternative is to use an afterDelete() trigger in the parent record to delete the child.

[kurisusan]

Thanks. I cannot change the db enginge, though.
As Record->delete() is not implemented, how do I delete a record? Using plain sql?

Christian

[shannah]

Yes. Best just to do mysql_query()