Purpose
RELEASE_ALL_LOCKS() releases all named locks held by the current session and returns the number of locks released.
Syntax
RELEASE_ALL_LOCKS
Description
Parameters
No parameters are involved.
Return value
The number of locks released is returned. 0 is returned if the current session does not hold any lock.
Examples
Release all named locks held by the current session.
obclient [(none)]> SELECT RELEASE_ALL_LOCKS();
The return result is as follows:
+---------------------+
| RELEASE_ALL_LOCKS() |
+---------------------+
| 1 |
+---------------------+
1 row in set
1 is returned, indicating that one named lock held by the current session was released.