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 ...

Cause: 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 ‘in (
‘1‘
)‘ at line 1

错误分析：

MySQL语法错误，并且是在第一行的“ in (‘1‘)‘ ” 的附近检查。

查找错误：

上面的SQL语句是错误的，这里不应该有“=”。

解决办法：

删除这个“=”号即可。

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 ...

标签：line   ati   技术分享   xxx   lan   tar   版本   target   应该