mysql-test/r/lock_multi.result


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

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;