AFTER Triggers
Learn AFTER Triggers (Triggers, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction An AFTER trigger fires once the row change has succeeded. NEW and OLD are read-only here, so AFTER triggers are for side effects : writing to another table, keeping a summary current, or recording history. Because the row exists, NEW.id already holds the generated AUTO_INCREMENT value.