https://www.cnblogs.com/duanxz/p/5099030.html mysql根据关联表对自身更新 update A inner join(select id,name from B) c on A.id = c.id set A.name = c.name;