1,修改1列
update cose_order o, cose_order_status_update os
set o.flow_status=1
where o.order_id = os.order_id;
2,修改多个列
update cose_order o, cose_order_status_update os
set o.flow_status=1 ,o.order_status=1
where o.order_id = os.order_id;
1,修改1列
update cose_order o, cose_order_status_update os
set o.flow_status=1
where o.order_id = os.order_id;
2,修改多个列
update cose_order o, cose_order_status_update os
set o.flow_status=1 ,o.order_status=1
where o.order_id = os.order_id;