Mysql更新列

Question

我有两张桌子fullInfo和fundInfo。fullInfo是一个向非营利性组织捐赠的完整数据集。fundInfo是一个唯一的基金子组列表，带有相应的id号。我正在尝试将fundInfo中的基金id号插入到fullInfo中的列fundId中，该列存在但当前值为空值。

fullInfo

id          funddesc          amount        fundId
002         GENERAL           25.00          NULL
044         MAINT             50.00          NULL
122         TRAVEL            75.00          NULL
...          ...               ...            ...

fundInfo

id          funddesc
01           MAINT
02           TRAVEL
03           GENERAL
...            ...

update fullInfo
set fullInfo.fundId = fundInfo.id
where fullInfo.funddesc = fundInfo.funddesc;

此代码不起作用。有什么建议吗？

Answer 1

UPDATE fullInfo
    INNER JOIN fundInfo
        ON fullInfo.funddesc = fundInfo.funddesc
    SET fullInfo.fundId = fundInfo.id;

Answer 2

update fullInfo
set fullInfo.fundId = fundInfo.id
from
fundInfo
where fullInfo.funddesc = fundInfo.funddesc;