Database: on update and on delete - how to handle?

I'm using InnoDB.

When delete and update actions occur on a particular table, I need to开发者_如何转开发 make certain changes to other tables. Right now, I am dealing with that through code. I'm wondering if there is a benefit to me doing this in the DB level.

Any thoughts? Pros and cons to consider? Gotchas to look out for?

---

I think you may want to learn about using using MySQL Triggers. Some extra links:

Restrictions overview

MySQL Triggers FAQ

---

The benefit of doing that at the database level is that those requirements will be enforced for every user and every application. (Including you, when you're sleep-deprived and under pressure.)