Collections:
IS_FREE_LOCK() - Checking Lock Status
How to check the status of a user defined lock using the IS_FREE_LOCK() function?
✍: FYIcenter.com
IS_FREE_LOCK(lock) is a MySQL built-in function that returns 1 if a given user lock is free, 0 otherwise. For example:
SELECT GET_LOCK('MyLock', 60), IS_FREE_LOCK('MyLock'); -- +------------------------+------------------------+ -- | GET_LOCK('MyLock', 60) | IS_FREE_LOCK('MyLock') | -- +------------------------+------------------------+ -- | 1 | 0 | -- +------------------------+------------------------+ SELECT RELEASE_LOCK('MyLock'), IS_FREE_LOCK('MyLock'); -- +------------------------+------------------------+ -- | RELEASE_LOCK('MyLock') | IS_FREE_LOCK('MyLock') | -- +------------------------+------------------------+ -- | 1 | 1 | -- +------------------------+------------------------+
Reference information of the IS_FREE_LOCK() function:
IS_FREE_LOCK(lock): boolean Returns 1 if a given user lock is free, 0 otherwise. Arguments, return value and availability: lock: Required. The lock name to be examined. boolean: Return value. 1 if the lock is free, 0 otherwise. Available since MySQL 4.
⇒ IS_IPV4() - Detecting IPv4 Address
⇐ INET6_NTOA() - IPv6 Address Number to String
2023-12-20, 257🔥, 0💬
Popular Posts:
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...