This external resource looks like about the best tutorial I've seen yet for MySQL Triggers. I'm going to have to play with this, I've been putting off implementing some necessary triggers for lack of a clear tutorial to guide my first efforts.
http://forge.mysql.com/wiki/Triggers