[Solved] This AFTER INSERT trigger fails to compile:CREATE TRIGGER trg AFTER INSERT ON orders FOR EACH ROW BEGIN INSERT INTO audit VALUES (NEW.id, CURRENT_TIMESTAMP); END;What is the most likely error? | SQL

SQL - Triggers

This AFTER INSERT trigger fails to compile:

CREATE TRIGGER trg AFTER INSERT ON orders FOR EACH ROW BEGIN INSERT INTO audit VALUES (NEW.id, CURRENT_TIMESTAMP); END;

What is the most likely error?

AFOR EACH ROW is not allowed in AFTER triggers.

BMissing column list in INSERT INTO audit statement.

CCURRENT_TIMESTAMP is invalid in triggers.

DAFTER INSERT triggers cannot use NEW keyword.

Step-by-Step Solution

Solution:

Step 1: Check INSERT syntax
INSERT statements should specify columns if table has multiple columns.
Step 2: Identify missing column list
Without column list, if audit table has more than two columns, error occurs.
Final Answer:
Missing column list in INSERT INTO audit statement. -> Option B
Quick Check:
Always specify columns in INSERT inside triggers [OK]

Quick Trick: Specify columns in INSERT statements inside triggers [OK]

Common Mistakes:

Master "Triggers" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

This AFTER INSERT trigger fails to compile: