RELEASE_LOCK
You are viewing an old version of this article. View
the current version here.
Syntax
RELEASE_LOCK(str)
Description
Releases the lock named by the string str
that was obtained with GET_LOCK(). Returns 1 if the lock was released, 0 if the
lock was not established by this thread (in which case the lock is not
released), and NULL
if the named lock did not exist. The
lock does not exist if it was never obtained by a call to
GET_LOCK()
or if it has previously been released.
MariaDB until 10.0.2
Before 10.0.2, GET_LOCK()
released the existing lock, if any. Since 10.0.2 this does not happen, because multiple locks are allowed.
str
is case insensitive. If str
is an empty string or NULL
, RELEASE_LOCK()
returns NULL
and does nothing.
The DO statement is convenient to use with
RELEASE_LOCK()
.
See also
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.