mysql - 如何从另一个表的 2 个变量更新一个表？

Question

我有 2 个表，在表 A 中我有 id_A 和 region_A，在表 2 中我有 id_B > 和 region_B

当 id_A 等于 id_B 时，我想设置 region_A = Region_B

我读到this question

并尝试过:

UPDATE  A  SET  A.`region` =   B.region  
FROM  A   
inner join B    on A.id_a = B.id_b 

我收到这个错误

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM A inner join B on A.id_a' at line 1

如何更新我的表 A？

Answer 1

这是 SQL Server 语法。试试这个:

UPDATE Α AS t1
INNER JOIN Β AS t2
    ON t1.region = t2.region
SET t1.id_a = t2.id_b