UPDATE shop_order AS A, shop_order AS B
SET A.shipping_time = B.shipping_time
A.`status`=B.status
A.shipping_code=B.shipping_code,
WHERE A.order_sn =B.order_sn
SET A.shipping_time = B.shipping_time
A.`status`=B.status
A.shipping_code=B.shipping_code,
WHERE A.order_sn =B.order_sn