update table1 a1 inner join (select a.id from table1 a
inner join table2 b
on b.id=a.id
where b.name='nameValue')tmp on a1.id=tmp.id
set a1.item='value'
mysql 根据B表字段 修改 A表中的值
最新推荐文章于 2023-05-17 10:20:09 发布
update table1 a1 inner join (select a.id from table1 a
inner join table2 b
on b.id=a.id
where b.name='nameValue')tmp on a1.id=tmp.id
set a1.item='value'