mysql - 使用 join 更新查询不工作 MySQL

Question

这个问题已经有答案了:

Inner Join Nested Inside Update Statement SQL (1 个回答)

已关闭 5 年前。

UPDATE rates_master
  SET rates_master.fees_information = rates_master_old.fees_information 
from rates_master
  INNER JOIN rates_master_old
    ON rates_master.id=rates_master_old.id;

Answer 1

MySQL 中正确的语法是:

UPDATE rates_master rm JOIN
       rates_master_old rmo
       ON rm.id = rmo.id;
    SET rm.fees_information = rmo.fees_information ;