Triggers

BEFORE and AFTER triggers on INSERT, UPDATE and DELETE.

2 notes

Notes

Trigger Basics: BEFORE, AFTER, INSERT, UPDATE and DELETE

Code the database runs automatically when data changes. Learn the six trigger points, the NEW and OLD row references, and how to write an audit trigge...

SQL

Trigger Use Cases and Limitations

What triggers are genuinely good at, the costs they impose, and the honest list of reasons teams end up removing them.