需求:需要对插入数值做更新,更新数值依赖于插入数据;
解决方案:触发器:
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;;