觸發器

介紹

---

---

創建觸發器

---

---

-- 通過觸發器記錄 emp 表的數據變更日志 emp_logs , 包含增加, 修改 , 刪除 ; create trigger emp_insert_trigger after insert on emp for each row begininsert 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 begininsert 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 begininsert 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$

---

---

查看觸發器?

總結

以上是生活随笔為你收集整理的触发器——创建||更新||删除||查看的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。