https://www.cnblogs.com/wtcl/p/8398996.html

update table xxx as a inner join (select f1,f2 from xx) b set a.xx=b.f1 where a.xx=b.fx  ;