oceanbase

1
drop table if exists t1;
2
create table t1(pk int primary key, c1 int);
3
insert into t1 values(1,2), (2, 3),(3,4),(4,5);
4
select * from t1;
5
pk	c1
6
1	2
7
2	3
8
3	4
9
4	5
10
update t1 set c1=pk ;
11
select * from t1;
12
pk	c1
13
1	1
14
2	2
15
3	3
16
4	4
17
update t1 set c1=pk where pk=1 ;
18
select * from t1;
19
pk	c1
20
1	1
21
2	2
22
3	3
23
4	4
24
update t1 set c1=pk where pk in (1,2,3,4) ;
25
select * from t1;
26
pk	c1
27
1	1
28
2	2
29
3	3
30
4	4
31
update t1 set c1=pk-0 ;
32
select * from t1;
33
pk	c1
34
1	1
35
2	2
36
3	3
37
4	4
38