MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value
来源:互联网 发布:phpcms和帝国cms 编辑:程序博客网 时间:2024/05/16 07:15
org.apache.ibatis.exceptions.PersistenceException:
###Error updating database. Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value: ‘Putin’
The error may involve test.updateUser-Inline
The error occurred while setting parameters
SQL: update user set username = ? and address = ? where id = ?
Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value: ‘Putin’
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:26)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:154)
at mybatis01_start.Mybatis01.UpdateUser(Mybatis01.java:80)
···25 more
来来回回瞅了半天,原来是sql语句错了
update user set username = #{username} and address = #{address} where id = #{id}
把 and 改成 逗号 , OK
update user set username = #{username} , address = #{address} where id = #{id}
低级错误!!!sql语法错误
update语句,如果有更多的列,就用逗号连接,不是and
update 表名 set 字段名1 = 值1 , 字段名2 = 值2 , …. , 字段名n = 值n where 条件
注意:如果没有where条件,会将所有记录修改;
注意避免sql语句的语法错误,还是要习惯性地先在Navicat运行测试一下。。。
- MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value
- Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value: 'L
- Data truncation: Truncated incorrect DOUBLE value
- Data truncation: Truncated incorrect DOUBLE value: 'Y'
- Data truncation: Truncated incorrect DOUBLE value: 'xiaodi'
- Data truncation: Truncated incorrect DOUBLE value
- Mybatis Data truncation: Truncated incorrect DOUBLE value: '*'
- Data truncation: Truncated incorrect DOUBLE value:??错误.
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE
- Data truncation: Truncated incorrect DOUBLE value:Mysql Update时
- nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE的调错
- MysqlDataTruncation: Data truncation: Incorrect datetime value
- 当使用update语句时出现Data truncation: Truncated incorrect DOUBLE value:??错误.
- mysql使用update更新数据遇到的错误:Data truncation: Truncated incorrect DOUBLE value:Mysql Update
- RabbitMQ 小结
- hadoop搭建之网络配置
- Mysql之binlog日志说明及利用binlog日志恢复数据操作记录
- 十进制转化为二进制
- 强化学习的基础知识
- MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value
- 学生信息管理系统之第二篇主要功能模块设计和数据库设计
- Hive删除表
- python进行JB正态性检验
- volatile关键字解析(jdk1.5之后)
- Java线程常用操作方法
- JAVA小程序--裁判评分系统
- HTML5+JavaScript+CSS实现音乐播放器——难点一:动态生成播放列表
- matlab的gscale函数