有时候我们需要更新好几个表，一个个更新太麻烦，现在可以用left join 起来，联表更新，同时也可以用notepad 对操作日志进行正则替换
update ecshop.ecs_order_info oi
left join romeo.order_shipment os ON convert(oi.order_id using utf8) = os.order_id
left join romeo.shipment s ON os.shipment_id = s.shipment_id
left join ecshop.ecs_carrier_bill b ON oi.carrier_bill_id = b.bill_id
set oi.shipping_id = ’99’,oi.shipping_name=’汇通快递’,
s.shipment_type_id=’99’,s.carrier_id=’28’,b.carrier_id = ’28’,
s.tracking_number=’310010334597′,b.bill_no=’310010334597′
where
oi.order_id in(
6186486
);
replace into ecshop.ecs_order_action \(order_id,action_user,order_status,shipping_status,pay_status,action_time,action_note\) values \(‘\1′,’ljzhou’,1,1,2,now\(\),’erp转汇通快递’\);
