Problem using OLD variable in after update trigger

Question

I just want to know can I use the OLD keyword to retrieve the older value after updated. I am using this in After update trigger and I am not able to get the old value but new is working. Database being used is MYSQL. I have read in forums and some people are saying old will work and some are opposing that. Please clarify.

Thanks,
Karthik

Guffa · Accepted Answer · 2011-06-22 13:04:49Z

2

If you want to get the previous value, you should use a before trigger instead of an after trigger.

The trigger time is at what stage during the process takes place. This can be either BEFORE or AFTER. If using before this means that the trigger code will be able to work with both the values currently stored in there original state and the new values

MySQL Triggers : Trigger time

answered Jun 22, 2011 at 13:04

Guffa

703k111 gold badges760 silver badges1k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Problem using OLD variable in after update trigger

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related