在做快递查询时用的,删除时,产生触发器,产生日志。
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$