两张表关联-批量更新SQL

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;