Access original field value after modification by earlier trigger
Last updated on MARCH 08, 2017
Applies to:MySQL Server - Version 5.7 and later
Information in this document applies to any platform.
Suppose a table has two triggers with the same event and time, and that the first one modifies the NEW value of some field:
The second trigger gets the value of NEW.my_field that was set by the first trigger (that is, @x will hold 1 rather than 2). How can it get the original value supplied by the INSERT instead?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms