update A set AC3 = (select (BC3 + CC3) as MySum,bid from B,C where Bid = Cid).MySum where aid = (select (BC3 + CC3) as MySum,bid from B,C where Bid = Cid).bid没测试过,不知道行不行,只是提供个思路,你觉着行就试试看吧
update谢谢update 表A set 表A.AC3 = 表B.BC3+表C.CC3 where 表A.AID = 表B.BDI and 表B.BDI = 表C.CID 这个不行。。表B.BC3到这错了, 我开始也是这么写的。。不行,,555555555
update A set AC3 = (select (BC3 + CC3) as MySum,bid from B,C where Bid = Cid).MySum where aid = (select (BC3 + CC3) as MySum,bid from B,C where Bid = Cid).bid 有错,,不行。as MySum里面有一样的,
update 表A set 表A.AC3 = 表B.BC3+表C.CC3 where 表A.AID = 表B.BDI and 表B.BDI = 表C.CID 这样为什么不行,, 有谁会说说啊,
update test.a set a.a1 = ( select b.b1 + c.c1 from test.b,test.c where a.aid = b.bid and b.bid = c.cid) where exists ( select aid from test.b,test.c where a.aid = b.bid and b.bid = c.cid) 这次在mysql中测试过了正确不过至于你那个怎么不对我也讲不明白。
set AC3 = (select (BC3 + CC3) as MySum,bid from B,C where Bid = Cid).MySum
where aid = (select (BC3 + CC3) as MySum,bid from B,C where Bid = Cid).bid没测试过,不知道行不行,只是提供个思路,你觉着行就试试看吧
这个不行。。表B.BC3到这错了,
我开始也是这么写的。。不行,,555555555
set AC3 = (select (BC3 + CC3) as MySum,bid from B,C where Bid = Cid).MySum
where aid = (select (BC3 + CC3) as MySum,bid from B,C where Bid = Cid).bid
有错,,不行。as MySum里面有一样的,
这样为什么不行,,
有谁会说说啊,
select b.b1 + c.c1 from test.b,test.c where a.aid = b.bid and b.bid = c.cid)
where exists (
select aid from test.b,test.c where a.aid = b.bid and b.bid = c.cid)
这次在mysql中测试过了正确不过至于你那个怎么不对我也讲不明白。