Shulou(Shulou.com)05/31 Report--

Editor to share with you the difference between MySQL and Oracle trigger example analysis, I believe that most people do not know much about it, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to know it!

Trigger

Numbered category ORACLEMYSQL comment 1 create trigger statement different create or replace trigger TG_ES_FAC_UNIT

Before insert or update or delete on ES_FAC_UNIT

For each rowcreate trigger `hs_ esbs`.`TG _ INSERT_ES_FAC_ UNIT`BEFORE INSERT on `hs_ esbs`.`es _ fac_ unit`

For each row1. Oracle uses create or replace trigger syntax to create triggers.

Mysql uses create trigger to create triggers.

2. Oracle can trigger an insert,delete,update event in a trigger.

Mysql supports only one event per trigger. In other words, each trigger needs to be split into 3 mysql trigger.

3. Mysql trigger cannot be displayed or edited on the client side. You need to operate on the machine where the server resides. 2 trigger new and old record rows have different references to get new data:: new.FAC_CD

Get old data:: old.FAC_CD get new data: NEW.FAC_CD

Get the old data: OLD.FAC_CD1. References to new and old record rows:

Mysql is referenced by NEW.col1,OLD.col1.

Oracle is referenced by: NEW.col1,: OLD.col1.

2. NEW and OLD are not case sensitive. The above is all the contents of the article "sample Analysis of triggers for comparing MySQL with Oracle". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.