关于mysql trigger调用udf问题

yanebupt yanebupt 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
一个文件student.sql里内容
use yy;

DELIMITER |

DROP TRIGGER IF EXISTS student_trigger;
CREATE TRIGGER student_trigger
AFTER INSERT ON student
FOR EACH ROW BEGIN
SET @tt_json = (SELECT json_object(id,name) FROM student WHERE id = NEW.id LIMIT 1);
SET @tt_con = (SELECT redis_connect("10.1.60.125",6379));
SET @tt_resu = (SELECT redis_pipe(CONCAT("SET ",NEW.id," ",@tt_json,"\r\n")));

END |


DELIMITER ;


另一个文件student_new.sql内容


use yy;

DELIMITER |

DROP TRIGGER IF EXISTS student_update_trigger;
CREATE TRIGGER student_update_trigger AFTER UPDATE ON student;
FOR EACH ROW BEGIN
SET @tt_json = (SELECT json_object(id,name) FROM student WHERE id = NEW.id LIMIT 1);
SET @tt_con = (SELECT redis_connect("10.1.60.125",6379));
SET @tt_resu = (SELECT redis_pipe(CONCAT("SET ",NEW.id," ",@tt_json,"\r\n")));
END |

DELIMITER;



导入student_new.sql成功,导入student_new.sql提示:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';
FOR EACH ROW BEGIN
SET @tt_json = (SELECT json_object(id,name) FROM studen' at line 1


请大家帮忙看下,两个触发器操作是一样的,为什么一个成功一个不成功,看了n久都没看出问题。
...全文

相关推荐

评论 1
收藏 已收藏
分享
返回顶部
yanebupt
疑难问题 22,298 成员 121,727 内容