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, 399🔥, 0💬
Popular Posts:
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
How to put statements into a statement block in SQL Server Transact-SQL? You can put statements into...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...