MySQL 报错 Truncated incorrect INTEGER value: ''
某年某一天_:
我的应该最神奇,传参写死,工具上不报错,代码却报错。直接在count 内加了个去从才没问题。
[code=sql]
UPDATE
tms.`execution_order` eo
JOIN
(SELECT
bd.`do_order_id`,
COUNT(distinct IF(b.`bill_status` = 'transaction_bill_status_charge_off_pay',b.id,NULL)) AS chargeOffNum
FROM
tms.`transaction_bill` b
JOIN tms.`transaction_bill_detail` bd
ON bd.`transaction_bill_id` = b.`id`
WHERE bd.`do_order_id`='12312312312'
GROUP BY bd.`do_order_id`) bill
ON bill.do_order_id = eo.id SET eo.finish_audit = IF(
bill.chargeOffNum > 0,
'phy_type_paid',
'phy_type_audited'
)
WHERE eo.`if_entire_plan` IS NOT NULL
[/code]
|