mysql触发器insert更新自己_自己写的3个MySQL触发器insert、update、delete的小例子

-- update 操作的触发器例子drop trigger if exists csf_maec.tri_economic_dt_update;delimiter |create trigger csf_maec.tri_economic_dt_update after update on csf_maec.maec_datafor each row begininsert into csf_maec.maec_data_ecnomic(data_id, data_value, audit_status, data_notes, insert_user,insert_time, update_user, update_time, delete_user, delete_time,audit_user, audit_time, op_flag)select new.data_id, new.data_value, new.audit_status, new.data_notes, new.insert_user,new.insert_time, new.update_user, now(), new.delete_user, new.delete_time,new.audit_user, new.audit_time, concat('update ',user());end|delimiter ;-- insert操作的触发器例子drop trigger if exists csf_maec.tri_economic_dt_insert;delimiter |create trigger csf_maec.tri_economic_dt_insert after insert on csf_maec.maec_datafor each row begininsert into csf_maec.maec_data_ecnomic(data_id, data_value, audit_status, data_notes, insert_user,insert_time, update_user, update_time, delete_user, delete_time,audit_user, audit_time, op_flag)select new.data_id, new.data_value, new.audit_status, new.data_notes, new.insert_user,new.insert_time, new.update_user, new.update_time, new.delete_user, new.delete_time,new.audit_user, new.audit_time, concat('insert ',user());end|delimiter ;-- delete操作的触发器例子drop trigger if exists csf_maec.tri_economic_dt_delete;delimiter |create trigger csf_maec.tri_economic_dt_delete after delete on csf_maec.maec_datafor each row begininsert into csf_maec.maec_data_ecnomic(data_id, data_value, audit_status, data_notes, insert_user,insert_time, update_user, update_time, delete_user, delete_time,audit_user, audit_time, op_flag)select old.data_id, old.data_value, old.audit_status, old.data_notes, old.insert_user,old.insert_time, old.update_user, old.update_time, old.delete_user, now(),old.audit_user, old.audit_time,  concat('delete ',user());end|delimiter ;

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值