dead_lee · 2009-11-18 04:16:07 · 阅读: 375 en, 奇怪的想法, 不直接用update语句, 而且想加锁在更新? select * from t where a=1 and lock=0 and rownumber<2 for update