需求:需要对插入数值做更新,更新数值依赖于插入数据;
解决方案:触发器:
DELIMITER ;; CREATE TRIGGER `trigger_set_transittime` BEFORE INSERT ON `ptops` FOR EACH ROW begin set @diff=DATEDIFF(new.destdate,new.origdate)+1 ; if(diff>=0) then set NEW.transittime= diff; end if; end;;
需求:需要对插入数值做更新,更新数值依赖于插入数据;
解决方案:触发器:
DELIMITER ;; CREATE TRIGGER `trigger_set_transittime` BEFORE INSERT ON `ptops` FOR EACH ROW begin set @diff=DATEDIFF(new.destdate,new.origdate)+1 ; if(diff>=0) then set NEW.transittime= diff; end if; end;;