在游标定位在行中时,锁定这个被应用程序的某个事务访问的任何一行。
Locks any row accessed by a transaction of an application while the cursor is positioned on the row.
图17显示了游标定位在MYIDBAD用户ID的字母b上。
Figure 17 shows the cursor positioned at the letter B in the MYIDBAD user ID.
数据行只是在游标定位它们时才锁定,一旦获取下一行之后,锁将被解除。
Rows are only locked at the point in time that a cursor is positioned on them; once the next row is fetched, the lock is released.
应用推荐