1 echo create table t1
(f1 int not null
,f2 int
,f3 int
);
3 echo insert into t1 values
(1,2,3);
4 Statement Executed
: Rows Affected
= 1
5 echo insert into t1 values
(10,20,30);
6 Statement Executed
: Rows Affected
= 1
7 echo insert into t1 values
(100,200,300);
8 Statement Executed
: Rows Affected
= 1
9 echo insert into t1 values
(1000,2000,3000);
10 Statement Executed
: Rows Affected
= 1
11 echo select * from t1
;
12 ---------------------------------------------------------
14 ---------------------------------------------------------
20 echo update t1
set f2
=3333, f3
=4444 where f1
>=100;
21 Statement Executed
: Rows Affected
= 2
22 echo select * from t1
;
23 ---------------------------------------------------------
25 ---------------------------------------------------------