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, 1048🔥, 0💬
Popular Posts:
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How To Install Oracle Database 10g XE in Oracle? To install 10g universal edition, double click, Ora...