Add to Chrome
✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
Inside an INSERT trigger, which row variables are available?
Both OLD and NEW, exactly as in an UPDATE trigger.
OLD
NEW
Neither — INSERT triggers cannot see row data.
Only NEW.col_name — there is no old row on INSERT.
NEW.col_name
Only OLD.col_name — there is no new row yet.
OLD.col_name
Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!