MYSQL数据触发器的问题
各位大神:好!我写了一个MYSQL触发器,但是MYSQL数据库没有回应和执行,想了很多办法都没有解决。都快崩溃了,请大家指导一下。感谢!
DELIMITER $$
USE `esysdata`$$
DROP TRIGGER /*!50032 IF EXISTS */ `tri_sendorder2021004`$$
CREATE
/*!50017 DEFINER = 'admin123456'@'%' */
TRIGGER `tri_sendorder2021004` AFTER INSERT ON `t_cy_sendstockentry`
FOR EACH ROW BEGIN
DECLARE c VARCHAR(40) ;
DECLARE v INT;
SET c='';
SET c=(SELECT FFileName FROM t_cy_order WHERE fbillno=new.frelatebillno);
IF ISNULL(c)|| LENGTH(TRIM(c))<1 THEN
SET v = 1/0;
END IF;
END;
$$
DELIMITER ;