update tab1 as t1
left join
tab2 as t2
on t1.id=t2.id
set t1.aCol=t2.aCol
关联两表,根据一张表更新另一张
最新推荐文章于 2024-10-15 09:42:46 发布
update tab1 as t1
left join
tab2 as t2
on t1.id=t2.id
set t1.aCol=t2.aCol