MYSQL 更新语句报错
MYSQL 更新语句报错问题描述:相同的语句 查询的时候没有问题,转换成功更新语句就报错,错误信息:Truncated incorrect DOUBLE value: ‘21700-21800’查询SQL如下:select dcf.id as flightId,p.RATIO_MATCH as ratioMatch from der_certain_flight dcfLEFT JOIN ( SELECT flight_id, round(SUM(if(ABS(LEVEL_QA
原创
2020-09-02 11:10:05 ·
941 阅读 ·
0 评论