mysql关联更新

update orde_order as o inner join orde_delivery_address as da on o.id=da.order_id set o.delivery_number=CONCAT(o.delivery_number,da.postcode) where o.delivery_company='Colisprive' and LENGTH(o.delivery_number)=12 -- o.id='2c93ece063eea6870163f21dd5970001';