提示:这里描述项目中遇到的问题:
调用如下代码时
select * from star
star_id in
#{sid}
报错如下
### SQL: select * from star WHERe star_id in ### Cause: java.sql.SQLSyntaxErrorException: 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 '' at line 2 ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: 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 '' at line 2] with root cause
原因分析:
提示:这里填写问题的分析:
暂时未知,可能是版本问题
解决方案:
提示:这里填写该问题的具体解决方案:
将star_id in写入内部,代码如下:
select * from star
#{sid}



