Chapter 9: Triggers and Events
Chapter 9 of 15
Chapter 9: Triggers and Events
9.1 Triggers
Triggers automatically execute SQL code when certain events occur.
CREATE TRIGGER update_timestamp
BEFORE UPDATE ON users
FOR EACH ROW
SET NEW.updated_at = NOW();9.2 Events
Events are scheduled tasks that run automatically.
CREATE EVENT cleanup_old_sessions
ON SCHEDULE EVERY 1 DAY
DO
DELETE FROM sessions WHERE expires_at < NOW();