1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
drop table if exists t1; create table t1 (n int); insert into t1 values (1),(2),(3); select * from t1; n 1 2 3 drop table t1; SELECT GET_LOCK("dangling", 0); GET_LOCK("dangling", 0) 1 SELECT GET_LOCK('dangling', 3600);; SELECT GET_LOCK('dangling', 3600);; SELECT RELEASE_LOCK('dangling'); RELEASE_LOCK('dangling') 1 GET_LOCK('dangling', 3600) 1 |