mysql - 使用插入查询设置过程 MySQL 5.5 时出错

Question

出现错误“错误 1064 (42000):您的 SQL 语法有错误；请查看与您的 MySQL 服务器版本对应的手册，了解在 ') 附近使用的正确语法”

我在我的编码中没有发现任何错误的语法，但仍然找不到问题，

CREATE PROCEDURE sp_GetAssignTask(IN module varchar(100),IN did int,IN actstatus int,IN  act varchar(30),IN sdate datetime,IN edate datetime,OUT outmsg varchar(20))
BEGIN
DECLARE DateDuration int;
SET DateDuration = SELECT DATEDIFF(edate, sdate) ;
insert into sch_taskassigned   (Duration,Module,Content,Deptid,taskenddate,taskstartdate,activestatus,activity,subactivity)values (DateDuration,modul,conte,did,edate,sdate,actstatus,act,subact);
set outmsg = 'Added Successfully';
END 

Answer 1

我唯一能看到的语法问题是

SET DateDuration = (SELECT DATEDIFF(edate, sdate)); 注意我在等号后面添加了 ()。

另外，根据执行此操作的客户端，您可能需要更改分隔符，例如:

DELIMITER $$

CREATE PROCEDURE sp_GetAssignTask(IN module varchar(100),IN did int,IN actstatus int,IN  act varchar(30),IN sdate datetime,IN edate datetime,OUT outmsg varchar(20))
BEGIN
DECLARE DateDuration int;
SET DateDuration = (SELECT DATEDIFF(edate, sdate));
insert into sch_taskassigned   (Duration,Module,Content,Deptid,taskenddate,taskstartdate,activestatus,activity,subactivity)values (DateDuration,modul,conte,did,edate,sdate,actstatus,act,subact);
set outmsg = 'Added Successfully';
END

$$