SQL - Triggers
Which of the following is the correct syntax to reference the old value of a column named
price inside an UPDATE trigger?Which of the following is the correct syntax to reference the old value of a column named price inside an UPDATE trigger?
easy📝 Syntax Q3 of 15
Step-by-Step Solution
Solution:
Step 1: Recall syntax for OLD keyword usage
In SQL triggers, the old value of a column is accessed byOLD.column_name.Step 2: Validate options
OnlyOLD.pricematches the correct syntax; others are invalid.Final Answer:
OLD.price -> Option BQuick Check:
OLD.column_name syntax is correct [OK]
Quick Trick: Use OLD.column_name to get old value in UPDATE triggers [OK]
Common Mistakes:
- Using NEW.price for old value
- Incorrect syntax like OLD->price
- Reversing the order as price.OLD
Master "Triggers" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes