无法显示评分，无法评分，大佬帮忙看一下

[ghost]

2021-08-05 14:06:12.572 ERROR 13684 --- [nio-8888-exec-8] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException:

Error querying database. Cause: java.sql.SQLSyntaxErrorException: 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 'rank where songListId = 3' at line 1

The error may exist in file [D:\workspcae\j2project\music\music-server\target\classes\mapper\RankMapper.xml]

The error may involve defaultParameterMap

The error occurred while setting parameters

SQL: SELECT COALESCE(sum(score),0) as score from rank where songListId = ? ;

Cause: java.sql.SQLSyntaxErrorException: 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 'rank where songListId = 3' at line 1

; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: 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 'rank where songListId = 3' at line 1] with root cause

[ghost]

数据库版本问题吗还是啥

[Yin-Hongwei]

数据我有一个表名叫rank，但是在高版本的mysql里占用了这个名字，你把rank名字改一下就行了。