Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL
来源:互联网 发布:足球关注分析软件 编辑:程序博客网 时间:2024/05/01 19:15
关于这个错误信息网上的解法很多种,记录下我的原因,我是因为插入报错的,sql语句如下:
insert into t_kt_message(c_relaId,c_relContent) values
<foreach collection="list" item="item" index="index" separator=",">
(#{item.CRelaid,jdbcType=CHAR},#{item.CRelcontent,jdbcType=VARCHAR})
</foreach>
粘贴执行没有任何问题,所以并不是sql引起的错误信息
我因为是批量插入数据,所以传值过来的是一个List集合,但是如果是空的list集合就会引起上面的错误,一次提示下自己办的错误!
0 0
- Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL
- Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax.....
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax;解决办法
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax解决办法
- 解决com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax;错误
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax;
- mybatis报“com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL s”
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; che
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; che
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; che
- com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax;
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in
- Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 解决方案
- Spring JPA-Hibernate报错:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an er解决方案
- Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column ""in 'field lis
- Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'XXX' in 'whe
- hadoop学习之HDFS(2.4):hadoop数据类型与java数据类型的对比与转换
- 八大排序学习之四直接选择排序
- BannerLayoutSimple 支持图片无限轮播的 BannerLayout,支持自定义小圆点位置以及显示位置等等,反正支持的挺多的,源码也有注释
- GitHub 中国区前 100 名到底是什么样的人?
- javascript ajax上传图片
- Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL
- archlinux上安装sublime编辑器
- 关于布局填充器的参数
- 史上最适合 MVP 初学者学习的 DEMO,整体运用 OKhttp+Mvp+MD 风格设计
- memcahce使用
- 面向对象—工厂模式示例(数据库示例)
- linux SSH无密码登录设置 仍需输密码
- 返回指定的 的界面控制器
- 找到一个LINUX与WINDOWS实现实时文本通信的办法