1
SET @lock_name="release_lock_test";
2
SELECT get_lock(@lock_name);
5
SELECT if ((is_used_lock(@lock_name) = CONNECTION_ID()), "YES", "NO");
6
if ((is_used_lock(@lock_name) = CONNECTION_ID()), "YES", "NO")
8
SELECT release_lock(@lock_name);
9
release_lock(@lock_name)
11
SELECT is_used_lock(@lock_name);
12
is_used_lock(@lock_name)
14
SELECT release_lock(@lock_name);
15
release_lock(@lock_name)