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 ;