mysql触发器和oracle_mysql和oracle的各种触发器应用

#mysql触发器使用

mysql使用 触发器给主键设值

CREATE TRIGGER `ta_sp_applicant_his_trigger_id` BEFORE INSERT ON `ta_sp_applicant_his` FOR EACH ROW BEGIN

IF NEW.S_GUID = '' or NEW.S_GUID is null THEN

set NEW.S_GUID = uuid();

END IF;

END

mysql 使用触发器给另外一个表添加记录

CREATE TRIGGER `tr_table_trigger_insert` AFTER INSERT ON `tri_table` FOR EACH ROW BEGIN

insert into table(S_GUID,column) values(UUID(),NEW.column);

END

mysql 判断操作类型 做对应的响应

CREATE TRIGGER `td_sm_trigger_test` AFTER UPDATE ON `td_sm` FOR EACH ROW BEGIN

IF NEW.DATA_FLAG = 'delete' THEN

update ex_hn set S_STATUS = 2 where ORG_ID = NEW.ORG_ID;

END IF;

IF NEW.DATA_FLAG = 'update' THEN

update ex_hn set

ORG_NAME = NEW.ORG_NAME

,S_LAST_UPDATED = NEW.LAST_UPDATETIME

,S_STATUS = 1

,ORG_SHOWNAME = NEW.ORG_SHOWNAME

,PARENT_ID = NEW.PARENT_ID

,AREA_CODE = NEW.AREA_CODE

,ORDER_NUM = NEW.ORDER_NUM

,IS_VALID = NEW.IS_VALID

,LAST_UPDATETIME = NEW.LAST_UPDATETIME

,DATA_FLAG = NEW.DATA_FLAG

,MOD_FLAG = NEW.MOD_FLAG where ORG_ID = NEW.ORG_ID;

END IF;

END ;;