mysql从另一个表更新查询

Question

我想从名为更新表的临时表更新我的产品表中的一些字段。

到目前为止我有这个，但是我有一个 sql 错误，但我还找不到它是什么。

UPDATE destination 

SET destination.title = source.title, 
destination.title_tag = source.title_tag,
destination.keywords = source.keywords

FROM updated_table AS source

JOIN products AS destination ON source.id = destination.id

Answer 1

UPDATE products AS destination
JOIN updated_table AS source
ON source.id = destination.id
SET destination.title = source.title, 
destination.title_tag = source.title_tag,
destination.keywords = source.keywords