1 echo create table t1
(f1 int
,f2 char
(10));
3 echo insert into t1 values
(1,'x');
4 Statement Executed
: Rows Affected
= 1
5 echo insert into t1 values
(2,'y');
6 Statement Executed
: Rows Affected
= 1
7 echo set autocommit off
;
8 AUTOCOMMIT Mode is
set to OFF
9 echo delete from t1 where f1
=1;
10 Statement Executed
: Rows Affected
= 1
11 echo select * from t1
;
12 ---------------------------------------------------------
14 ---------------------------------------------------------
18 echo select * from t1
;
19 ---------------------------------------------------------
21 ---------------------------------------------------------
26 echo insert into t1 values
(3,'k');
27 Statement Executed
: Rows Affected
= 1
28 echo insert into t1 values
(4,'p');
29 Statement Executed
: Rows Affected
= 1
30 echo create table t2
(f1 int
,f2 char
(10));
32 echo delete from t1 where f1
=1;
33 Statement Executed
: Rows Affected
= 1
34 echo select * from t1
;
35 ---------------------------------------------------------
37 ---------------------------------------------------------
43 echo select * from t1
;
44 ---------------------------------------------------------
46 ---------------------------------------------------------