1
SELECT GET_LOCK("mine");
4
SELECT USER_NAME, USER_LOCK_NAME FROM DATA_DICTIONARY.USER_LOCKS;
5
USER_NAME USER_LOCK_NAME
7
CREATE TABLE lock_state (a int);
8
EXECUTE "INSERT INTO lock_state SELECT GET_LOCK(\"mine\", 20)" CONCURRENT;
9
SELECT RELEASE_LOCK(@LOCK);
12
DROP TABLE lock_state;