com.alibaba.druid.sql.parser.ParserException: syntax error,expect IS, actual EQ id

最新推荐文章于 2024-01-09 15:14:43 发布

原创最新推荐文章于 2024-01-09 15:14:43 发布 · 4.3w 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#sql

sql 专栏收录该内容

7 篇文章

订阅专栏

本文介绍了一个具体的SQL语法错误案例及解决方法。通过在表名后正确使用'as'关键字定义别名，解决了由语法错误导致的查询失败问题。

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

Caused by: com.alibaba.druid.sql.parser.ParserException: syntax error, error in :’icle.id = comment.article_id’,expect IS, actual EQ id

解决方法：表的别名前加上as

原sql

   SELECT
            article.id as article_id,
            article.title as article_title,
            article.content as article_content,
            article.author_id as article_author_id,
            comment.id as comment_id,
            comment.content as comment_content,
            comment.date as comment_date
        FROM
            article article
        LEFT  JOIN
            comment comment
        ON
            article.id = comment.article_id

现sql

   SELECT
            article.id as article_id,
            article.title as article_title,
            article.content as article_content,
            article.author_id as article_author_id,
            comment.id as comment_id,
            comment.content as comment_content,
            comment.date as comment_date
        FROM
            article as article
        LEFT  JOIN
            comment as comment
        ON
            article.id = comment.article_id