Question

Mysql创建触发器时提示new表不存在，怎么解决？

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
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 $$
DELIMITER ;
上面是写的触发器
一直提示1109，unknown table 'new' in field list sql statement

Answer 1

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 ;