Java调用MySQL的Function出现does not exist!

控制台不报错,但是在mysql里运行这条语句] select t.ccticallid, f_getAgentNameAndID(t.cbizagentid) cbizagentid,t.istandardid,t.ichkruleid,t.istate,t.dtotalscore,f_getAgentNameAndID(t.cagentid) cagentid,t.cfinishtime,t.iappraise,t.ichecktimes,t.isessiontimes,t.cremark,t.iisouttime,t.irowid,t.itenantid,t.igatherid,t.ccreatetime,f_getqcXnameByID('standard',istandardid) as cstandardname,f_getqcXnameByID('prj',ICHKRULEID) as cprjname,f_getqcXnameByID('task',IGATHERID) as cgathername,getdictvalue('CheckTaskStatus',t.istate,'zh_CN',161) as cstate ,getGroupByAgentID(t.cbizagentid) as groupname from t_chk_project_result t left join tcalllog tc on t.ccticallid = tc.ccticallid where 1=1的时候报1305 - FUNCTION ky.f_getqcXnameByID does not exist这个错误,大神求解答,查了一天了

2个回答

 错误码: 1630
FUNCTION count does not exist. Check the'Function Name Parsing and Resolution' section in the Reference Manual
解决方案:如sum() count() avg这些函数里面是这样子写的sum () sum和()分开了,不是挨着写的,所以报这个错
......
答案就在这里:错误码: 1630 FUNCTION count does not exist. Check the 'Function Name Parsing and Resolution' section in
----------------------Hi,地球人,我是问答机器人小S,上面的内容就是我狂拽酷炫叼炸天的答案,除了赞同,你还有别的选择吗?

查了是mysql里没有这个函数,但是怎么加入这个函数呢?

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
立即提问
相关内容推荐