SQL Triggers: Understanding Trigger Events

Create an UPDATE Trigger

Write a trigger that logs changes to a 'products' table's price column.

Expected output: A trigger that inserts a record into a price_changes log table when the price is updated.

Hint: Use OLD and NEW references to compare values.

Combine Multiple Trigger Events

Create a trigger that fires on both INSERT and DELETE events on an 'orders' table to maintain an audit log.

Expected output: A trigger that logs both new orders and deleted orders.

Hint: Specify multiple events in the trigger definition if supported.

The main trigger events are INSERT, UPDATE, and DELETE, which correspond to data being added, modified, or removed from a table.

Yes, a trigger can be defined to fire on one or more events, such as both INSERT and UPDATE, depending on the database system's capabilities.

BEFORE triggers execute before the triggering event occurs, allowing modification or validation, while AFTER triggers execute after the event, typically for logging or cascading actions.