summaryrefslogtreecommitdiff
path: root/mysql-test/r/lock_multi.result
blob: 6fe8cc71185780eb72d42c6e67b26545b3c6f605 (plain)
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;