UPDATE tb1 as t1,tb2 SET t1.fd1=tb2.fd1 where t1.fd2=tb2.fd2 and t1.fd3=tb2.fd3
或
update a inner join(select f1,f2 from b) c on a.f1 = c.f1 set a.f2 = c.f2
UPDATE tb1 as t1,tb2 SET t1.fd1=tb2.fd1 where t1.fd2=tb2.fd2 and t1.fd3=tb2.fd3
或
update a inner join(select f1,f2 from b) c on a.f1 = c.f1 set a.f2 = c.f2
转载于:https://my.oschina.net/jingshishengxu/blog/993723