1292 (22007): Truncated incorrect DOUBLE value: ''
来源:互联网 发布:c高级编程第11版 pdf 编辑:程序博客网 时间:2024/06/09 23:56
查看sql模式
mysql> show session variables like '%sql_mode%';
+---------------+--------------------------------------------+
| Variable_name | Value |
+---------------+--------------------------------------------+
| sql_mode | STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION |
+---------------+--------------------------------------------+
mysql> show session variables like '%sql_mode%';
+---------------+--------------------------------------------+
| Variable_name | Value |
+---------------+--------------------------------------------+
| sql_mode | STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION |
+---------------+--------------------------------------------+
1 row in set (0.00 sec)
mysql> update tbl_user_details set nickname=CONCAT("用户",yunva_id) where nickname = yunva_id;
ERROR 1292 (22007): Truncated incorrect DOUBLE value: '糖糖的坤大叔'
解决办法:设置sql_mode为非严格模式,问题解决
mysql> set sql_mode='NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
Query OK, 0 rows affected (0.00 sec)
mysql> show session variables like '%sql_mode%';
+---------------+--------------------------------------------+
| Variable_name | Value |
+---------------+--------------------------------------------+
| sql_mode | NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+---------------+--------------------------------------------+
1 row in set (0.00 sec)
阅读全文
0 0
- 1292 (22007): Truncated incorrect DOUBLE value: ''
- Truncated incorrect DOUBLE VALUE:
- Truncated incorrect DOUBLE value
- ERROR 1292 (22007): Truncated incorrect DOUBLE value: '96133dby11'
- SQLSTATE[22007]: Invalid datetime format: 1292 Truncated incorrect DOUBLE value
- Error : Truncated incorrect DOUBLE value
- mysql Truncated incorrect DOUBLE value
- 解决sql update 1292 - Truncated incorrect DOUBLE value:
- 93 mysql 1292-Truncated incorrect double value 错误
- 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: '*'
- mysql 出现 Truncated incorrect DOUBLE value:
- ibatis Truncated incorrect DOUBLE value: '12,18'
- MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value
- Truncated incorrect DOUBLE value: 报错
- 一些参考的博客
- lhgdialog回调父窗口(上一层窗口)方法
- SpringMVC日期类型转换问题三大处理方法归纳
- avfilter_graph_create_filter初始化buffersrc失败
- LinkedHashMap的实现原理
- 1292 (22007): Truncated incorrect DOUBLE value: ''
- 将input隐藏域value作为缓存的存储数据,以便在其他地方使用这些数据。
- Java中统计字符串中各字符出现的次数
- 6_springboot项目1(eclipse)
- CSS3改变表单控件光标的颜色
- js生成指定范围内的随机整数
- Android 设计模式之适配器模式
- java实现按照文件的修改时间排序文件夹下的文件
- 网络编程——基础部分