RELEASE_LOCK( )

This MySQL function releases a lock created by GET_LOCK().

Syntax

RELEASE_LOCK(string)

Explanation

This function releases a lock created by GET_LOCK(). The name of the lock is given in parentheses. If successful, 1 is returned; if unsuccessful, 0 is returned. If the lock specified does not exist, NULL is returned.

Examples

SELECT RELEASE_LOCK('my_lock');

+-------------------------+
| RELEASE_LOCK('my_lock') |
+-------------------------+
|                       1 |
+-------------------------+

As an alternative to using SELECT, you can use the DO statement. In this case, no results are returned, but the lock is released.

DO RELEASE_LOCK('my_lock');