For the example, it is not the SELECT statement that caused the problematic lock, but the UPDATE statement executed just before the SELECT statement in the same transaction.

例如，不是select语句造成产生问题的锁，但update语句恰好在同一事务中在select语句前执行。

youdao

The update clause will ensure that an update lock is held on the selected rows.

更新子句将确保更新锁定在被选择的行上。

youdao

The normal behaviour of a database access is to get a read lock on the queried data, which gets transformed into an update lock if data is updated.

数据库访问通常会对被查询的数据进行读锁定，在数据更新后会变成更新锁定。

youdao

This update fixes a number of lock screen bypass vulnerabilities that have plagued the platform since iOS 6 was released.

FORBES: Move up http://i.forbesimg.com t Move down

The goal is to help organizations better secure smartphones and tablets in the workplace with a hosted service that allows the IT team to remotely locate, lock or wipe a lost or stolen device, as well as update software to protect against spyware and viruses.

FORBES: The Pros And Cons Of 'Bring Your Own Device'

As communicated in the July 30 Franchise Weekly Update , a hacker claims to have compromised the Onity brand guestroom lock system with a device containing a circuit board with several wires attached.

FORBES: Lock Firm Onity Starts To Shell Out For Security Fixes To Hotels' Hackable Locks