Using values from an insert in a trigger

Question

I'm using a trigger that triggers AFTER INSERT, when the user inserts data into the the table i want to be able to use the information that was just inserted into the table in my trigger.

Is there any way to do this?

Progman · Accepted Answer · 2020-05-21 19:23:01Z

1

Use the special variable new to get the data for the new added row(s), as described in the manual at 13.1.22 CREATE TRIGGER Statement

Within the trigger body, you can refer to columns in the subject table (the table associated with the trigger) by using the aliases OLD and NEW. OLD.col_name refers to a column of an existing row before it is updated or deleted. NEW.col_name refers to the column of a new row to be inserted or an existing row after it is updated.

answered May 21, 2020 at 19:23

Progman

20.1k7 gold badges58 silver badges88 bronze badges

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

1 Comment

Linus Liljequist Over a year ago

Yeah, i totally glossed over that, this is my bad and i should not have missed this.

Collectives™ on Stack Overflow

Using values from an insert in a trigger

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related