[Solved] Given this trigger code:CREATE TRIGGER check_age BEFORE INSERT ON users FOR EACH ROW BEGIN IF NEW.... END;What happens if you try to insert a user with age 16? | SQL

SQL - Triggers

Given this trigger code:

CREATE TRIGGER check_age BEFORE INSERT ON users FOR EACH ROW BEGIN IF NEW.age < 18 THEN SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Age must be 18 or older'; END IF; END;

What happens if you try to insert a user with age 16?

AThe insert fails with an error message 'Age must be 18 or older'

BThe age is automatically set to 18

CThe insert is ignored silently

DThe insert succeeds and user is added

Step-by-Step Solution

Solution:

Step 1: Understand trigger logic
The trigger checks if NEW.age is less than 18 and raises an error if true.
Step 2: Apply to age 16
Since 16 < 18, the trigger raises an error with message 'Age must be 18 or older', stopping the insert.
Final Answer:
The insert fails with an error message 'Age must be 18 or older' -> Option A
Quick Check:
BEFORE trigger can stop invalid inserts [OK]

Quick Trick: BEFORE triggers can block invalid data with SIGNAL [OK]

Common Mistakes:

Thinking insert succeeds despite error
Assuming silent ignore instead of error
Believing trigger changes data automatically

Master "Triggers" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More SQL Quizzes

Given this trigger code:

Step 1: Understand trigger logic

Step 2: Apply to age 16

Final Answer:

Quick Check:

Want More Practice?