MySQL语法错误异常 : Error while upgrading MySQL version

Question

当我使用连接器版本 5.1.48 将 MySQL 版本从 5.7.22 升级到 8.0.18 时，我在查询中遇到以下错误:

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'member on r.user_role_id = member.user_role_id left join action_permission p on' at line 1

查询如下:

select p.name 
from users u 
    left join user_role r on u.user_role_id = r.user_role_id 
    left join user_role_action_permission member on r.user_role_id = member.user_role_id 
   left join action_permission p on member.permission_id = p.permission_id 
where p.NAME = ? 
and u.USER_ID = ?

帮我解决这个问题。提前谢谢你。

Answer 1

Keywords and Reserved Words

MEMBER; added in 8.0.17 (reserved); became nonreserved in 8.0.19

报价。或者升级到 8.0.19。