[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 找了半天都木有找到?
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;
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 ;