xiaozhuaia 发表于 2018-9-30 08:21:00

MySQL5.7多表关联更新

　　update ord a
　　inner join room b on a.roomno=b.roomno
　　inner join flat c on a.flatno = c.flatno and a.flatsub=c.flatsub
　　set a.xrea = b.xrea,
　　a.ritysubn=b.ritysubn,
　　a.blockno=b.blockno,
　　a.blockn=b.blockn,
　　a.part=b.part,
　　a.unit=b.unit,
　　a.layer=b.layer,
　　a.home=b.home,
　　a.flatn=c.flatn;

页: [1]
查看完整版本: MySQL5.7多表关联更新