For Update 与 For Update of 区别
1 :select * from TTable1 for update 锁定表的所有行,只能读不能写 2 :select * from TTable1 where pkid = 1 for update 只锁定pkid=1的行 3 :select * from Table1 a join Table2 b on a.pkid=b.pkid for update 锁定两个表的所有记录
转载
2009-04-23 15:11:00 ·
567 阅读 ·
0 评论