4 echo create table t2
(f1 int
,f2 float
,f3
date);
7 DEFAULT AUTOCOMMIT MODE ON
8 echo insert into t2 values
(10,100.001,'2001-1-1');
9 Statement Executed
: Rows Affected
= 1
10 echo insert into t2 values
(50,500.005,'2005-5-5');
11 Statement Executed
: Rows Affected
= 1
12 echo insert into t2 values
(10,100.001,'2001-1-1');
13 Statement Executed
: Rows Affected
= 1
14 echo insert into t2 values
(20,200.002,'2002-2-2');
15 Statement Executed
: Rows Affected
= 1
16 echo insert into t2 values
(30,300.003,'2003-3-3');
17 Statement Executed
: Rows Affected
= 1
18 echo SET AUTOCOMMIT OFF
;
19 AUTOCOMMIT Mode is
set to OFF
20 echo insert into t2 values
(100,1000.0001,'2001-1-1');
21 Statement Executed
: Rows Affected
= 1
22 echo insert into t2 values
(500,5000.0005,'2005-5-5');
23 Statement Executed
: Rows Affected
= 1
24 echo insert into t2 values
(100,1000.0001,'2001-1-1');
25 Statement Executed
: Rows Affected
= 1
26 echo insert into t2 values
(200,2000.0002,'2002-2-2');
27 Statement Executed
: Rows Affected
= 1
28 echo insert into t2 values
(300,3000.0003,'2003-3-3');
29 Statement Executed
: Rows Affected
= 1
30 echo select * from t2
;
31 ---------------------------------------------------------
33 ---------------------------------------------------------
34 10 100.000999 2001/1/1
35 50 500.005005 2005/5/5
36 10 100.000999 2001/1/1
37 20 200.001999 2002/2/2
38 30 300.002991 2003/3/3
39 100 1000.000122 2001/1/1
40 500 5000.000488 2005/5/5
41 100 1000.000122 2001/1/1
42 200 2000.000244 2002/2/2
43 300 3000.000244 2003/3/3