1
SELECT get_lock("foo");
2
SELECT release_lock("foo");
3
SELECT get_lock("foo", 1);
4
SELECT release_lock("foo");
5
SELECT get_lock("foo", 10);
6
SELECT release_lock("foo");
8
set @lock_name= "new_name";
9
SELECT get_lock(@lock_name);
10
SELECT if ((is_used_lock(@lock_name) = CONNECTION_ID()), "YES", "NO");
11
SELECT release_lock(@lock_name);