mysql 根据相同字段将A表多条数据=修改到B表

ped表：

umap表：

问题：根据两表相同字段Individual ID,将ped表的Population字段对应到UMAP表的Population字段。

解决：

update umap,ped set umap.Population = ped.Population where umap.`Individual ID` = ped.`Individual ID`;

参考：
https://blog.csdn.net/qq_39313596/article/details/107107724