一个文件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久都没看出问题。MySQLudftrigger
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久都没看出问题。MySQLudftrigger
解决方案 »
- 在网上找了个把word文件存在数据库中的存储过程,但在自己的机器上试验读入word文件时候并不成功,提示“'textcopy' 不是内部或外部命令,也不是可运行的程序或批处理文件。NULL”这个过程有什么问题吗?存储过程如下(根据实际情况自己做了修改):
- 求推荐书目
- 求问
- Sql 2008 数据库查询慢
- sqlserver internet连接,极难!!
- 求一sql语句批量更新价格?
- sql2005数据库还原报错,请专家解答,谢谢~
- 请问在SQL server2000中,如何给数据库改名呢?
- 关于数据库的连接(在windows98环境下,sql server7。0)
- 一个有关视图的问题
- 请教一个sql查询的问题
- 求一SQL查询写法
SET @tt_json = (SELECT json_object(id,name) FROM studen' at line 1
错误是说你这条语句附近有问题啊.有什么特殊空格?