[Err] 1064 - 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 '' at line 6
找了半天都木有找到?
找了半天都木有找到?
解决方案 »
- 坑爹要求,表某字段值排序!!!求帮助
- 求解:MYSQL tirgger触发器 delete 2个表中的是数据 请大师帮忙
- mysql 语句优化
- 排行榜的问题,如果设置榜单排名?
- postgresql 中有没有类似sqlserver中 #table1 或declare @table1 table(id int,age int);的语法
- postgres 的存储过程 请高手帮忙看看 急急急
- 请教mysql innodb数据文件大小超过系统限制的问题
- mysql是怎么运行的呢,我一开始运行就是一个黑屏.......是软件的问题吧.
- my.ini的如何设置 才能提高性能
- Mysql语言问题!!请大家多指教
- 服务器几十个php站 都出现 数据库链接失败
- mysql大表拆分,求方法
IN var_agentid VARCHAR (32),
IN var_ruleid VARCHAR (32),
IN var_createid VARCHAR (32))
BEGIN
DECLARE var_count INT DEFAULT 0;
DECLARE var_noticeId VARCHAR(300);
/*开始事物*/
SET AUTOCOMMIT=0;
SELECT count(1) INTO var_count FROM driver_agent_relation WHERE agent_id = var_agentid and work_status = 4; SET var_noticeId = REPLACE(UUID(),'-','');
INSERT INTO notices (notice_id,notice_type,object_id,title,
agent_id,create_time,create_user,read_num,re,totype,
STATUS,push_time,push_num
)VALUES(var_noticeId,2,var_ruleid,'提成规则修改',var_agentid,NOW(),var_createid,
0,'提成规则修改',2,1,OW(),var_count); INSERT INTO notice_people (notice_people_id,notice_id,notice_type,people_id,
response_result,STATUS
) SELECT REPLACE(UUID(),'-',''),var_noticeId,1,driver_id,0,1
FROM driver_agent_relation WHERE agent_id = var_agentid and work_status = 4;
SELECT var_count; /*提交事物*/
COMMIT;
END;
delimiter &&
create ....
...
BGEIN
...
END;
&&
delimiter ;
CREATE DEFINER = `root`@`%` PROCEDURE `sp_drive_notices`(
IN var_agentid VARCHAR (32),
IN var_ruleid VARCHAR (32),
IN var_createid VARCHAR (32))
BEGIN
DECLARE var_count INT DEFAULT 0;
DECLARE var_noticeId VARCHAR(300);
/*开始事物*/
SET AUTOCOMMIT=0;
SELECT count(1) INTO var_count FROM driver_agent_relation WHERE agent_id = var_agentid and work_status = 4;SET var_noticeId = REPLACE(UUID(),'-','');
INSERT INTO notices (notice_id,notice_type,object_id,title,
agent_id,create_time,create_user,read_num,re,totype,
STATUS,push_time,push_num
)VALUES(var_noticeId,2,var_ruleid,'提成规则修改',var_agentid,NOW(),var_createid,
0,'提成规则修改',2,1,OW(),var_count);INSERT INTO notice_people (notice_people_id,notice_id,notice_type,people_id,
response_result,STATUS
) SELECT REPLACE(UUID(),'-',''),var_noticeId,1,driver_id,0,1
FROM driver_agent_relation WHERE agent_id = var_agentid and work_status = 4;
SELECT var_count;/*提交事物*/
COMMIT;
END;
//
delimiter ;