玖叶教程网

mysql中update和select结合使用,根据b.xm更新a.xm,b.xb→a.xb

update sb a inner join(select * from yl) b

on a.sfzh = b.shbzhm set a.xm= b.xm,a.xb=b.xb;