sql异常：Encountered unexpected token: “.“ “.“

最新推荐文章于 2022-07-20 00:44:40 发布

码上致富

最新推荐文章于 2022-07-20 00:44:40 发布

阅读量3.8w

点赞数 4

分类专栏： JAVA 文章标签： mysql mybatis

本文链接：https://blog.youkuaiyun.com/mashangzhifu/article/details/118928664

版权

在使用Mybatis-Plus进行排序操作时出现异常："Encountered unexpected token: "." ".""。分析发现是由于SQL中的关键字冲突导致，尤其是'database'和'show'。通过检查并移除这些关键字，问题得以解决。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

一、问题描述

在用mybatis-plus的过程中，没排序就好好的，一旦排序，报如下错误：

net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "." "."
    at line 14, column 11.

Was expecting one of:

    "&"
    ","
    "::"
    ";"
    "<<"
    ">>"
    "ACTION"
    "ANY"
    "AS"
    "BYTE"
    "CASCADE"
    "CAST"
    "CHANGE"
    "CHAR"
    "CHARACTER"
    "COLLATE"
    "COLUMN"
    "COLUMNS"
    "COMMENT"
    "COMMIT"
    "CONNECT"
    "CYCLE"
    "DESC"
    "DESCRIBE"
    "DISABLE"
    "DIV"
    "DO"
    "DUPLICATE"
    "ENABLE"
    "END"
    "EXCEPT"
    "EXCLUDE"
    "EXTRACT"
    "FALSE"
    "FIRST"
    "FN"
    "FOLLOWING"
    "FOR"
    "FORMAT"
    "FROM"
    "GROUP"
    "HAVING"
    "INDEX"
    "INSERT"
    "INTERSECT"

最低0.47元/天解锁文章