Chapter 11. Triggers
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
(INSERT, UPDATE, 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.
Get MySQL Stored Procedure Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
