Audit Logging with Triggers
Learn Audit Logging with Triggers (Triggers, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction Audit logging records who changed what, when, and the before/after values. The classic MySQL pattern is an audit table written by AFTER INSERT/UPDATE/DELETE triggers using OLD , NEW , CURRENT_USER() and NOW() .