UPDATE table_1 AS a
INNER JOIN (
SELECT
relation_columns,
update_columns
FROM
table_2
) AS b ON a.relation_columns = b.relation_columns
SET a.update_columns = b.update_columns;
两张表关联-批量更新SQL
最新推荐文章于 2023-11-12 18:43:09 发布