update b set bc1 = ( select ac1 from a where a.aid = b.bid)
where exists (select 1 from ac1 where a.aid = b.bid)
UPDATE b
SET b.bc1=a.ac1
WHERE a.aid=b.bid
update b,a
set b.bc1=a.ac1
where b.bid=a.id;
update b set b.bid=a.ac1 where a.aid=b.bid
q
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024