一个文件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久都没看出问题。而且每次调整student_new.sql里语句前面的空格 执行导入student_new.sql提示的错误位置也不一样
ERROR 1064 (42000) at line 37: 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 st' at line 1求大神帮忙
MySQLtriggersql
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久都没看出问题。而且每次调整student_new.sql里语句前面的空格 执行导入student_new.sql提示的错误位置也不一样
ERROR 1064 (42000) at line 37: 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 st' at line 1求大神帮忙
MySQLtriggersql
解决方案 »
- 被TRIGGER影响的记录无法手动删除?
- 将SQLSER数据用DTS导入到MYSQL中遇到问题急
- (100分愿闻其详)MySQL如何做到高并发、高可用性、高性能
- MySql手册中将event.txt导入数据库产生问题表格不整齐
- delete 后面是不是不能跟 in 语句?
- 怎样实现这样的模糊查询方法
- 有关mysql的几个小问题?
- MYSQL5.5.38的my.cnf参数选项设置问题
- MySQL 始终连不上 本地也一样 Navicat 连接完全没问题,但是一旦AS JAVA 代码连接就出现如下错误 麻烦大神解救啊!!!!!!!!!!!!!!!
- MySQL数据库出现trx_mysql_thread_id=0的线程,无法用kill杀死。如何解决?
- 求教一个触发器里的参数问题
- linuc mysql c ap 调用查询函数引起崩溃
CREATE TRIGGER student_update_trigger AFTER UPDATE ON student;
FOR EACH ROW BEGIN student;
这个地方多了";"