mysql5.5触发器的问题_MySQL
来源：懂视网
责编：小采
时间：2020-11-09 19:58:46
mysql5.5触发器的问题_MySQL
mysql5.5触发器的问题_MySQL:1064正确的写法如下：DELIMITER $$CREATE TRIGGER `tkdsp_setspxx` BEFORE DELETE ON `tkdsp` FOR EACH ROW BEGIN update spxx set kcsl=kcsl-old.sl,kczj=kcsl*jhprice where spid=old.spid; END$$
导读mysql5.5触发器的问题_MySQL:1064正确的写法如下：DELIMITER $$CREATE TRIGGER `tkdsp_setspxx` BEFORE DELETE ON `tkdsp` FOR EACH ROW BEGIN update spxx set kcsl=kcsl-old.sl,kczj=kcsl*jhprice where spid=old.spid; END$$
1064
正确的写法如下：
DELIMITER $$
CREATE TRIGGER `tkdsp_setspxx` BEFORE DELETE ON `tkdsp` FOR EACH ROW BEGIN
update spxx set kcsl=kcsl-old.sl,kczj=kcsl*jhprice where spid=old.spid;
END$$
DELIMITER ;
记一下
mysql5.5触发器的问题_MySQL
mysql5.5触发器的问题_MySQL:1064正确的写法如下：DELIMITER $$CREATE TRIGGER `tkdsp_setspxx` BEFORE DELETE ON `tkdsp` FOR EACH ROW BEGIN update spxx set kcsl=kcsl-old.sl,kczj=kcsl*jhprice where spid=old.spid; END$$
