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, 271🔥, 0💬
Popular Posts:
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...