MYSQL 更新语句报错 问题描述: 相同的语句 查询的时候没有问题,转换成功更新语句就报错,错误信息: Truncated incorrect DOUBLE value: ‘21700-21800’ 查询SQL如下: select dcf.id as flightId,p.RATIO_MATCH as ratioMatch from der_certain_flight dcf LEFT JOIN ( SELECT flight_id, round(SUM(if(ABS(LEVEL_QAR-LEVEL_PLAN)