当前位置:Gxlcms > 数据库问题 > 批量更新sql

批量更新sql

时间: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   更新   

人气教程排行