Skip to main content

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() .

More lessons in Triggers