mysql中触发器中分隔符_php – 在触发器中使用分隔符的Mysql错误

最新推荐文章于 2022-03-26 15:02:17 发布

巫师财经

最新推荐文章于 2022-03-26 15:02:17 发布

阅读量122

点赞数

文章标签： mysql中触发器中分隔符

本文链接：https://blog.csdn.net/weixin_28754395/article/details/113459651

版权

博客内容涉及在PHP中使用MySQL触发器的代码实现。作者遇到一个问题，当尝试通过PHP执行创建触发器的SQL语句时，代码无法正常工作，而在phpMyadmin中直接运行则没有问题。代码中包含了检查条件、更新和插入操作。作者怀疑问题可能出在SQL语句的格式化或执行方式上。

摘要由CSDN通过智能技术生成

这是我的

mysql触发器语句

DELIMITER |

CREATE TRIGGER kk AFTER UPDATE

ON location FOR EACH ROW

BEGIN

IF NEW.name not in(SELECT A.name FROM filter A WHERE (NEW.name = A.name))THEN

IF NEW.location_name != OLD.location_name THEN

INSERT INTO filter(old_location_name,new_location_name)

VALUES (OLD.location_name, NEW.location_name);

ELSE

UPDATE filter SET old_location_name = OLD.location_name , new_location_name = NEW.location_name WHERE name = OLD.name;

END IF;

ELSE

UPDATE filter SET old_location_name = OLD.location_name , new_location_name = NEW.location_name WHERE name = OLD.name;

END IF;

END;|

DELIMITER ;

当我在phpMyadmin中粘贴此代码时,这很好用.

在我的项目中

$sqlDrop = "DROP TRIGGER IF EXISTS `kk`";

$resDrop = parent::_executeQuery($sqlDrop);

echo $sql = "same above delimiter trigger query";

$rs = parent::_executeQuery($sql );

现在$sql语句在一行中回声

DELIMITER | CREATE TRIGGER kk AFTER UPDATE ON location FOR EACH ROW BEGIN IF NEW.name not in(SELECT A.name FROM filter A WHERE (NEW.name = A.name))THEN IF NEW.location_name != OLD.location_name THEN INSERT INTO filter(old_location_name,new_location_name,name) VALUES (OLD.location_name, NEW.location_name); ELSE UPDATE filter SET old_location_name = OLD.location_name , new_location_name = NEW.location_name WHERE name = OLD.name; END IF; ELSE UPDATE filter SET old_location_name = OLD.location_name , new_location_name = NEW.location_name WHERE name = OLD.name; END IF; END;| DELIMITER ;

并且不执行查询.当我在我的phpMyadmin中粘贴echoed语句时,它显示我的错误