1292 - Truncated incorrect DOUBLE value: '#REF!' 完美! 简单粗暴,字符串参数要用引号引起了,不加引号在查询的时候正常,一旦执行插入和更新操作时就会报错: SELECT els,sum(returnAmount) as total1 FROM t_scf_received WHERE els = 750020 上面的SQL中的 750020 要加上引号 ‘750020’ 完美!