postgresql批量更新表的某一列
** 表bsvc_order_tel与表bsvc_order_details关联字段为order_id,要将bsvc_order_details中的org_id字段的内容更新到bsvc_order_tel表中的org_id字段**
update bsvc_order_tel set org_id = orgId from (
select details.org_id as orgId ,
details.order_id as orderId
from bs
原创
2021-07-20 14:55:19 ·
1060 阅读 ·
0 评论