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