mysql - 根据 MySQL 中连接的结果更新表

Question

我理解这里的语法:

UPDATE table
SET column1 = expression1,
    column2 = expression2,
    ...
WHERE conditions;

这里:

UPDATE table1
SET column1 = (SELECT expression1
               FROM table2
               WHERE conditions)
WHERE conditions;

...但是如果我想更新怎么办

UPDATE table1
SET column1 = expression
if we get a particular result on a join between table1 and table2
which has WHERE conditions?

我似乎无法弄清楚，而且我在所有尝试中都遇到了语法错误。非常感谢任何建议。

Answer 1

MySQL 的语法是:

UPDATE table1 JOIN
       table2
       ON conditions
    SET table1.column1 = table2.expression1
    WHERE conditions;