求助各位大神帮忙,我的sql语句如下
update main a left join basic b on a.holder_job_code = b.if_id set a.holder_job_code = b.id where a.holder_job_code != '0'
执行后报错Truncated incorrect DOUBLE value: a.holder_job_code 为 varchar(100)
b.id 为char(10)到底是什么问题啊??
update main a left join basic b on a.holder_job_code = b.if_id set a.holder_job_code = b.id where a.holder_job_code != '0'
执行后报错Truncated incorrect DOUBLE value: a.holder_job_code 为 varchar(100)
b.id 为char(10)到底是什么问题啊??
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货