USE `test`;
DELIMITER $$
DROP TRIGGER IF EXISTS test.desktop_test_AFTER_INSERT$$
USE `test`$$
CREATE DEFINER = CURRENT_USER TRIGGER `test`.`desktop_test_AFTER_INSERT` AFTER INSERT ON `desktop_test` FOR EACH ROW
begin
set @tv=1000 ;
set @newdate=new.cdate ;
set @newh=new.h ;
insert into check_log_test select cdate,h,(case when pv_pc<=@tv then 1 else 0 end),pv_pc from desktop_test where cdate=@newdate and h=@newh ;
end;
DELIMITER ;
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024