update b
set B = (select A
from a
where a.C = b.C and a.A<>=b.B
and row <= 1000)
where exists(select 1 from a
where a.C = b.C and a.A<>=b.B));
set B = (select A
from a
where a.C = b.C and a.A<>=b.B
and row <= 1000)
where exists(select 1 from a
where a.C = b.C and a.A<>=b.B));
http://community.csdn.net/Expert/TopicView3.asp?id=4816106乱码还原问题!
http://community.csdn.net/Expert/TopicView3.asp?id=4813786关于javabean反射代理的问题
http://community.csdn.net/Expert/TopicView3.asp?id=4813935
while(rs.next()){...}
rs.setFetchSize(1000);这条语句是什么意思??To:hxycxp()
谢谢你的SQL语句。我想每次处理1000条并且用JAVA程序代码处理,就是想减少数据库的压力,我打算尽可能的减少对数据库的检索,如果嵌套查询的话,查找量还是挺大的。还是很谢谢你!!