[Solved] What do the OLD and NEW keywords represent in an UPDATE trigger? — Ans: OLD is the data before update; NEW is the data after update | SQL

SQL - Triggers

What do the OLD and NEW keywords represent in an UPDATE trigger?

A<code>OLD</code> and <code>NEW</code> both represent the data before update

B<code>OLD</code> is the data after update; <code>NEW</code> is the data before update

C<code>OLD</code> and <code>NEW</code> both represent the data after update

D<code>OLD</code> is the data before update; <code>NEW</code> is the data after update

Step-by-Step Solution

Solution:

Step 1: Understand trigger timing
In an UPDATE trigger, OLD holds the row data before the update happens.
Step 2: Understand data after update
NEW holds the row data after the update is applied.
Final Answer:
OLD is the data before update; NEW is the data after update -> Option D
Quick Check:
OLD = before, NEW = after [OK]

Quick Trick: OLD = before update, NEW = after update [OK]

Common Mistakes:

Master "Triggers" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

What do the OLD and NEW keywords represent in an UPDATE trigger?