You have an error in your SQL syntax; check the manual that corresponds to your MySQL server versio

转角人生

于 2017-04-12 16:01:38 发布

阅读量828

点赞数

分类专栏：异常处理文章标签：异常

本文链接：https://blog.youkuaiyun.com/xuanzhangran/article/details/70143779

版权

异常处理专栏收录该内容

2 篇文章

订阅专栏

前台页面出现如下异常
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 'condition = 80.0,

后台出现如下异常：   
   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 'condition = 80.0,  


   原因：说明 condition 在数据库中是关键字，不可以直接使用 
   解决方案：将condition 加上  'condition' ，比如: 'condition' = #{condition }即可