how to create trigger on any change in table

Question

I have a mysql table which on any change (i.e. insert, update and delete) I need to run the relevant trigger code.
Do I need to create three different triggers or is there a syntax for just one.
Using mysql 5.1

Oleg Dok · Accepted Answer · 2012-01-17 18:54:30Z

1

Three triggers may perform better and AFAIK - there is no possibility to create multi-action trigger in MySQL, but I hope the syntax for one trigger is:

CREATE TRIGGER Name AFTER INSERT ON Table
FOR EACH ROW
begin
...
END

edited Jan 17, 2012 at 18:54

answered Jan 17, 2012 at 18:45

Oleg Dok

21.9k4 gold badges48 silver badges55 bronze badges

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

Collectives™ on Stack Overflow

how to create trigger on any change in table

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