summaryrefslogtreecommitdiff
path: root/mysql-test/r/lock_multi.result
blob: 20bc9b9572f6c59d9b8a5daf990a267b2fedc66e (plain)
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);
lock tables t1 write;
 update low_priority t1 set n = 4;
 select n from t1;
unlock tables;
n
4
drop table t1;
create table t1(n int);
insert into t1 values (1);
lock tables t1 read;
 update low_priority t1 set n = 4;
 select n from t1;
unlock tables;
n
1
drop table t1;