Collections:
RELEASE_ALL_LOCKS() - Release All Locks
How to release all locks associated with the current connection session using the RELEASE_ALL_LOCKS() function?
✍: FYIcenter.com
RELEASE_ALL_LOCKS(lock) is a MySQL built-in function that releases all locks associated with the current connection session. It returns the number of locks released. For example:
SELECT GET_LOCK('MyLockX', 60), GET_LOCK('MyLockY', 60); -- +-------------------------+-------------------------+ -- | GET_LOCK('MyLockX', 60) | GET_LOCK('MyLockY', 60) | -- +-------------------------+-------------------------+ -- | 1 | 1 | -- +-------------------------+-------------------------+ SELECT IS_USED_LOCK('MyLockX'), IS_USED_LOCK('MyLockY'); -- +-------------------------+-------------------------+ -- | IS_USED_LOCK('MyLockX') | IS_USED_LOCK('MyLockY') | -- +-------------------------+-------------------------+ -- | 307 | 307 | -- +-------------------------+-------------------------+ SELECT RELEASE_ALL_LOCKS(); -- +---------------------+ -- | RELEASE_ALL_LOCKS() | -- +---------------------+ -- | 2 | -- +---------------------+ SELECT IS_USED_LOCK('MyLockX'), IS_USED_LOCK('MyLockY'); -- +-------------------------+-------------------------+ -- | IS_USED_LOCK('MyLockX') | IS_USED_LOCK('MyLockY') | -- +-------------------------+-------------------------+ -- | NULL | NULL | -- +-------------------------+-------------------------+
Note that when a session connection is terminated, all locks associated with the connection will be released automatically.
Reference information of the RELEASE_ALL_LOCKS() function:
RELEASE_ALL_LOCKS(): count releases all locks associated with the current connection session, and returns the number of locks released. Arguments, return value and availability: count: Return value. Number of locks released. Available since MySQL 4.
Related MySQL functions:
⇒ RELEASE_LOCK() - Release Lock Instance
⇐ NULLIF() - NULL on Equal Values
2023-12-20, 319🔥, 0💬
Popular Posts:
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...