blob: 98eb3c4ec83698d2e01799c280fd1d3cd9f9cf2d (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
set autocommit=off;
drop table if exists t;
create table t (a int, b int, primary key (a)) engine=innodb;
start transaction;
insert into t values (1,2),(2,4),(3,8);
commit;
start transaction;
select * from t;
a b
1 2
2 4
3 8
commit;
start transaction;
truncate table t;
rollback;
start transaction;
select * from t;
a b
commit;
drop table t;
|
