MySQL Forums
Forum List  »  Triggers

What SQL statements generate UPDATE events?
Posted by: Joel Carbonera
Date: December 13, 2015 11:57PM


If I'm note wrong, so far (in the version 5.7 of MySQL), only three types of SQL statements can cause the server to execute a trigger: insertions, deletions, and updates.

INSERT events, however, are generated by INSERT statements, LOAD DATA statements, and REPLACE statements.

Similarly, DELETE events are generated by both DELETE and REPLACE statements because REPLACE potentially deletes rows as well as inserting them.

What statements generate UPDATE events?

Does the REPLACE statement generate an UPDATE event? Is there any other statement that generated UPDATE events?

Thank you in advance.
Best regards.

Options: ReplyQuote

Written By
What SQL statements generate UPDATE events?
December 13, 2015 11:57PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.