update pay_charge_order o
join pay_charge_company c
on o.company_id = c.id
set interface_supplier_id = (
case
when interface_type = 5
then 26
when interface_type = 0
then 17
end
)
where o.interface_supplier_id = 0
and o.interface_type in (0,5)
and c.type = 2
and o.addtime between DATE_SUB(curdate(), INTERVAL 1 MONTH) and now();
注意:end 不要忘记
另附一个详细的参考地址:https://blog.csdn.net/u013514928/article/details/80969949