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 update t1
set f2
='X';
27 Statement Executed
: Rows Affected
= 2
28 echo insert into t1 values
(3,'k');
29 Statement Executed
: Rows Affected
= 1
30 echo insert into t1 values
(4,'p');
31 Statement Executed
: Rows Affected
= 1
33 echo select * from t1
;
34 ---------------------------------------------------------
36 ---------------------------------------------------------
42 echo update t1
set f2
='Z';
43 Statement Executed
: Rows Affected
= 4
44 echo create table t2
(f1 int
,f2 char
(10));
46 echo delete from t1 where f1
=1;
47 Statement Executed
: Rows Affected
= 1
48 echo select * from t1
;
49 ---------------------------------------------------------
51 ---------------------------------------------------------