Data truncation: Truncated incorrect DOUBLE value

来源:互联网 发布:php图书管理系统下载 编辑:程序博客网 时间:2024/05/16 10:29
update nb_order set biz_context = biz_context + "mailNo=550457371017;mailNoDate=1468036800000;"  where user_id = 62916164 and  id = 23666483


Data truncation: Truncated incorrect DOUBLE value: ';cpServiceTimeDesc=2小时内快速上门;discountType=1;orderServiceTimeDesc=2小时内快速上门;cpServiceTime=2H;antispamVa'


修改为CONCAT解决,原因未定:

update nb_order set biz_context = CONCAT(biz_context , "mailNo=550457371017;mailNoDate=1468036800000;")  where user_id = 62916164 and  id = 23666483

0 0
原创粉丝点击