Access original field value after modification by earlier trigger (Doc ID 1591517.1)

Last updated on MARCH 08, 2017

Applies to:

MySQL Server - Version 5.7 and later
Information in this document applies to any platform.

Goal

 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?

Solution

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