for update 和 for update of 有什么区别

最新推荐文章于 2024-01-25 16:40:02 发布

墨守成规如何成功

最新推荐文章于 2024-01-25 16:40:02 发布

阅读量3.7k

点赞数

分类专栏： php数据库学习

本文链接：https://blog.csdn.net/qq_29965101/article/details/80435372

版权

php数据库学习专栏收录该内容

1 篇文章 0 订阅

订阅专栏

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

锁定两个表的所有记录

这个有语句是锁定俩表的符合id匹配条件的所有记录,而不是锁定俩表的所有记录.予以更正

(这个有语句是锁定俩表的符合id匹配条件的所有记录,而不是锁定俩表的所有记录.予以更正)

4

select * from Table1 a join Table2 b on a.pkid=b.pkid where a.pkid = 10 for update

锁定两个表的中满足条件的行

5.

select * from Table1 a join Table2 b on a.pkid=b.pkid where a.pkid = 10 for update of a.pkid

只锁定Table1中满足条件的行

备注:

for update of 说得不对，根据 oracle文档，它是用来锁字段的。

http://download.oracle.com/docs/cd/E11882_01/appdev.112/e10826/pco03dbc.htm#i4233

Restrictions

You cannot use FOR UPDATE with multiple tables, but you must use FOR UPDATE OF to identify a column in the table that you want locked.Row locks obtained by a FOR UPDATE statement are cleared by a COMMIT, which explains why the cursor is closed for you. If you try to fetch from a FOR UPDATE cursor after a commit, Oracle generates a Fetch out of Sequence error.