oceanbase

1
case 1: commit
2
show variables like 'autocommit';
3
Variable_name	Value
4
autocommit	ON
5
drop table if exists t1;
6
create table t1 (c1 int primary key, c2 varchar(1024));
7
set autocommit=0;
8
insert into t1 values (1, '中国');
9
select * from t1 where c1 = 1 for update;
10
c1	c2
11
1	中国
12
commit;
13
set autocommit=1;
14
select * from t1;
15
c1	c2
16
1	中国
17