[Solved] You wrote this trigger:CREATE TRIGGER trg_before_insert BEFORE INSERT ON orders FOR EACH ROW BEGIN SET NEW.order_date = CURRENT_DATE; END;But it causes an error. What is the likely problem? | SQL

SQL - Triggers

You wrote this trigger:

CREATE TRIGGER trg_before_insert BEFORE INSERT ON orders FOR EACH ROW BEGIN SET NEW.order_date = CURRENT_DATE; END;

But it causes an error. What is the likely problem?

AMissing delimiter change before trigger body

BIncorrect table name

CUsing AFTER instead of BEFORE

DTrigger event is not supported

Step-by-Step Solution

Solution:

Step 1: Recognize delimiter usage in triggers
Triggers often require changing the delimiter to avoid parsing errors.
Step 2: Identify missing delimiter change
Without changing delimiter, the parser misinterprets the trigger body.
Final Answer:
Missing delimiter change before trigger body -> Option A
Quick Check:
Delimiter must be changed before trigger creation [OK]

Quick Trick: Change delimiter before trigger body to avoid syntax 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: