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, 339🔥, 0💬
Popular Posts:
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...