SQL-从另一个表更新表-语法错误

错误1064是一个MySQL错误。如果您使用的是MySQL,正确的语法是:

UPDATE matches m JOIN
       teams t
       ON m.hometeam = t.teamcode
    SET m.hometeam = t.teamname;

然而,这不会真正起作用。您需要做的是添加ID:

alter table matches add hometeamcode int;

然后做:

UPDATE matches m JOIN
       teams t
       ON m.hometeam = t.teamcode
    SET m.hometeamcode = t.teamname;

matches 表应具有整数代码,引用中的行 teams .

您只需编写查询即可获得名称:

select m.*, th.teamname as hometeamname, ta.teamname as awayteamname
from matches m join
     team th
     on m.hometeam = th.teamcode join
     team ta
     on a.hometeam = ta.teamcode;

如果你不想做这件事 join