执行修改语句update tbl_user_details set nickname=CONCAT("用户",yunva_id) where nickname = yunva_id;
报错:
ERROR 1292 (22007): Truncated incorrect DOUBLE value: '糖糖的坤大叔'
查看sql模式
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为非严格模式
报错:
ERROR 1292 (22007): Truncated incorrect DOUBLE value: '糖糖的坤大叔'
查看sql模式
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为非严格模式