Stored Procedures and Triggers
Automate reusable database logic with procedures and triggers.
Stored Procedures and Triggers
Stored procedures help reuse database logic, while triggers can automatically respond to inserts, updates, or deletes.
sql
CREATE TRIGGER update_modified_time
BEFORE UPDATE ON students
FOR EACH ROW
SET NEW.updated_at = CURRENT_TIMESTAMP;