"
How To Use Triggers to Track Changes in MySQL
I don’t think there is anyway to do it in the database, but you can still put the logic in your application. If you are using django, there are signals that will help get that done. http://docs.djangoproject.com/en/1.0/topics/sig… If you aren’t then you will need to program it into your project in some other way.
Read more comments by Greg Allard
