[Solved] You wrote this trigger to log deletions:CREATE TRIGGER log_delete AFTER DELETE ON orders FOR EACH ROW BEGIN INSERT INTO audit_orders (order_id,... END;Why does this trigger cause an error? | SQL

SQL - Triggers

You wrote this trigger to log deletions:

CREATE TRIGGER log_delete AFTER DELETE ON orders FOR EACH ROW BEGIN INSERT INTO audit_orders (order_id, deleted_at) VALUES (NEW.id, NOW()); END;

Why does this trigger cause an error?

AMissing FOR EACH STATEMENT clause

BUsing NEW keyword in a DELETE trigger causes an error

CNOW() function is not allowed in triggers

DTrigger must be BEFORE DELETE, not AFTER DELETE

Step-by-Step Solution

Solution:

Step 1: Recall OLD and NEW usage in triggers
In DELETE triggers, only OLD is available because the row is removed; NEW does not exist.
Step 2: Identify the error cause
The trigger uses NEW.id in a DELETE trigger, which causes an error because NEW is undefined.
Final Answer:
Using NEW keyword in a DELETE trigger causes an error -> Option B
Quick Check:
DELETE triggers use OLD, not NEW [OK]

Quick Trick: Use OLD in DELETE triggers, NEW causes errors [OK]

Common Mistakes:

Master "Triggers" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

You wrote this trigger to log deletions: