请问这个存储过程哪里有问题?为什么调用时没有反应 ?
CreateproceduremodifyPwd(inmes_jobstatevarchar(20),inmes_committimevarchar(32))Beginu...
Create procedure modifyPwd(in mes_jobstate varchar(20),in mes_committime varchar(32))
Begin
update message set mes_jobstate= "未完成" where mes_jobstate in ("正在进行","延期拒绝","延期进行") and to_days(now())-to_days(mes_committime) >0;
End 展开
Begin
update message set mes_jobstate= "未完成" where mes_jobstate in ("正在进行","延期拒绝","延期进行") and to_days(now())-to_days(mes_committime) >0;
End 展开
1个回答
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询