Database triggers are stored programs that are executed in response to some
kind of event that occurs within the database. In the current MySQL
implementation of triggers, triggers fire in response to a DML statement
DELETE) on a specified table.
Triggers are a powerful mechanism for ensuring the integrity of your data, as well as a useful means of automating certain operations in the database, such as denormalization and audit logging.