What SQL statements generate UPDATE events?
Hello.
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.
Subject
Views
Written By
Posted
What SQL statements generate UPDATE events?
1993
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.