玖叶教程网

mysql8.0.22报函数sum不存在

1630 - FUNCTION sxxhzj.sum does not exist. 
Check the 'Function Name Parsing and Resolution' section in the Reference Manual

SQL代码如下

SELECT loader2, b.fullname, sum(tudi) sum_tudi, sum(xiaoshoue) sum_xse
        from custinfo a
        lEFT JOIN yuangong_info b on a.loader2=b.CODE
        GROUP BY loader2, b.fullname
        ORDER BY sum (xiaoshoue) DESC

如图处，原来是sum和(xiaoshoue)之间多了一个空格。

删除空格后执行成功！

mysql8.0.22

2020-12-27