Comparison between MySQL and Oracle six triggers, mysqloracle
Trigger
No. |
Category |
ORACLE |
MYSQL |
Note |
1 |
Different trigger creation statements |
Create or replace trigger TG_ES_FAC_UNIT Before insert or update or delete on ES_FAC_UNIT For each row |
Create trigger 'hs _ esbs '. 'tg _ INSERT_ES_FAC_UNIT' before insert on 'hs _ esbs '. 'es _ fac_unit' For each row |
1. Oracle uses the create or replace trigger syntax to create a trigger. Mysql uses create trigger to create a trigger. 2. Oracle can trigger insert, delete, and update events on a trigger. Each Mysql trigger supports only one event. That is to say, each trigger must be split into three mysql triggers. 3. mysql trigger cannot be displayed or edited on the client. You need to operate on the server. |
2 |
The reference of the trigger new and old record rows is different. |
Get new data: new. FAC_CD Get old data: old. FAC_CD |
Get NEW data: NEW. FAC_CD Get OLD data: OLD. FAC_CD |
1. Reference of new and old record rows: Mysql is referenced by NEW. col1, OLD. col1. Oracle is: NEW. col1,: OLD. col1 to reference. 2. NEW and OLD are case insensitive. |