主页 M

删除时,产生触发器

2014-06-17 网页编程网 网页编程网

在做快递查询时用的,删除时,产生触发器,产生日志。

CREATE TRIGGER create_log_delete AFTER DELETE ON nbs_kdList
FOR EACH ROW
BEGIN
INSERT INTO nbs_kdList_log (id,name,phone,selfNo,receive,isGet,input,isMessage,getTime,schoolCard,remark,action)
VALUES(old.id,old.name,old.phone,old.selfNo,old.receive,old.isGet,old.input,old.isMessage,old.getTime,old.schoolCard,old.remark,'delete');
END$

阅读原文
阅读 3778
123 显示电脑版