时间:2021-07-01 10:21:17 帮助过:25人阅读
跨库 批量更新
UPDATE a.table_1up
INNER JOIN (
SELECT
user_id,
user_org_company_id,
FROM
b.table_2
) AS tmp ON up.user_id = tmp.user_id
SET up.company_id = tmp.user_org_company_id,
批量更新sql
标签:sele 跨库 from sel inner 批量 _id sql 更新