触发器——创建||更新||删除||查看

触发器

介绍

---

---

创建触发器

---

---

-- 通过触发器记录 emp 表的数据变更日志 emp_logs , 包含增加, 修改 , 删除 ; 	
create trigger emp_insert_trigger
after insert
on emp
for each row
begin
  
  insert into emp_logs(id,operation,operate_time,operate_id,operate_params) values(null,'insert',now(),new.id,concat('插入后(id:',new.id,', name:',new.name,', age:',new.age, ', salary: ', new.salary,')'));
  
end$

---

---

create trigger emp_update_trigger
after update
on emp
for each row
begin
  
  insert into emp_logs(id,operation,operate_time,operate_id,operate_params) values(null,'update',now(),new.id, concat('修改前(id:',old.id,', name:',old.name,', age:',old.age, ', salary: ', old.salary,'), 修改后(',new.id,', name:',new.name,', age:',new.age, ', salary: ', new.salary));
  
end$

---

---

create trigger emp_delete_trigger
after delete
on emp
for each row
begin
  
  insert into emp_logs(id,operation,operate_time,operate_id,operate_params) values(null,'delete',now(),old.id, concat('删除前(id:',old.id,', name:',old.name,', age:',old.age, ', salary: ', old.salary,')'));
  
end$

---

---

查看触发器