RELEASE_LOCK(string)

Description: Releases an advisory lock named string. Used in conjunction with GET_LOCK(). Returns 1 if lock is released successfully, 0 if lock is held by a different thread (a thread can only release its own locks), or NULL if no lock exists with the name string.

See also: GET_LOCK() for full explanation and examples

Get Sams Teach Yourself MySQL in 21 Days, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.