I am familiar with the
ON DELETE CASCADE method, but I don't want to do a real delete, just a soft delete. This is implemented with a column named isDeleted (0/1).
Is there a way for me to cascade this soft delete from a parent to a child? A built in command? or is up to me to write the code?
I am thinking that what I am doing is in fact an update. So I'd be using an
ON UPDATE CASCADE, but will that update the same columns on the FKs? or just the primary key?