【异常】net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: “sequence“ “SEQUENCE“_exception: net.sf.jsqlparser.parser.parseexception

Caused by: net.sf.jsqlparser.JSQLParserException: null
	at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatements(CCJSqlParserUtil.java:151)
	at com.baomidou.mybatisplus.extension.parser.JsqlParserSupport.parserMulti(JsqlParserSupport.java:46)
	... 155 common frames omitted
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "sequence" "SEQUENCE"
    at line 1, column 86.

Was expecting one of:

    "!"
    "("
    "NOT"
1
2
3
4
5
6
7
8
9
10
11
12

原来的xml文件：

    <delete id="deleteBreedProjectPermissionById">
         delete from breed_project_permission where breed_project_id = #{breedProjectId} and grant_type=#{grantType} and sequence = #{sequence}
    </delete>
1
2
3

修改后：

    <delete id="deleteBreedProjectPermissionById">
         delete from breed_project_permission where breed_project_id = #{breedProjectId} and grant_type=#{grantType} and `sequence` = #{sequence}
    </delete>
1
2
3

用反引号括起来即可

相关文章：https://blog.csdn.net/mashangzhifu/article/details/118928664