如何在单个SQL查询中执行多个更新？

UPDATE table1 SET column1 = value1 WHERE condition1;
UPDATE table2 SET column2 = value2 WHERE condition2;

UPDATE table1
JOIN table2 ON table1.column = table2.column
SET table1.column1 = value1, table2.column2 = value2
WHERE table1.condition1 AND table2.condition2;

UPDATE table
SET column1 = CASE
    WHEN condition1 THEN value1
    WHEN condition2 THEN value2
    ELSE column1
END,
column2 = CASE
    WHEN condition3 THEN value3
    WHEN condition4 THEN value4
    ELSE column2
END
WHERE condition1 OR condition2 OR condition3 OR condition4;