Collections:
IS_USED_LOCK() - Checking Lock Owner
How to check the owner of a user defined lock using the IS_USED_LOCK() function?
✍: FYIcenter.com
IS_USED_LOCK(lock) is a MySQL built-in function that
returns the connection id the lock associated with if the lock is in use,
NULL otherwise.
For example:
SELECT GET_LOCK('MyLock', 60), IS_USED_LOCK('MyLock');
-- +------------------------+------------------------+
-- | GET_LOCK('MyLock', 60) | IS_USED_LOCK('MyLock') |
-- +------------------------+------------------------+
-- | 1 | 307 |
-- +------------------------+------------------------+
SELECT RELEASE_LOCK('MyLock'), IS_USED_LOCK('MyLock');
-- +------------------------+------------------------+
-- | RELEASE_LOCK('MyLock') | IS_USED_LOCK('MyLock') |
-- +------------------------+------------------------+
-- | 1 | NULL |
-- +------------------------+------------------------+
Reference information of the IS_USED_LOCK() function:
IS_USED_LOCK(lock): boolean
Returns the connection id the lock associated with if the lock is in use,
NULL otherwise.
Arguments, return value and availability:
lock: Required. The lock name to be examined.
boolean: Return value. Connection id the lock associated with
if the lock is in use, NULL otherwise.
Available since MySQL 4.
⇒ ISNULL() - Detecting NULL Value
⇐ IS_IPV6() - Detecting IPv6 Address
2023-12-20, 1733🔥, 0💬
Popular Posts:
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
How to print value on console in SQL Server Transact-SQL? How to use the PRINT statements? In Transa...
What Are the Basic Features of a Trigger in SQL Server? Since a SQL Server trigger is a really an ev...