1 echo create table t1
(f1 int
, f2 char
(10), f3 bigint
);
3 echo insert into t1 values
(10,'india',1234321);
4 Statement Executed
: Rows Affected
= 1
5 echo insert into t1
(f1
, f2
) values
(20,'INDIA');
6 Statement Executed
: Rows Affected
= 1
7 echo insert into t1
(f2
, f3
) values
('orissa',123432);
8 Statement Executed
: Rows Affected
= 1
9 echo insert into t1
(f1
, f3
) values
(30,123432);
10 Statement Executed
: Rows Affected
= 1
11 echo select * from t1
;
12 ---------------------------------------------------------
14 ---------------------------------------------------------
20 echo update t1
set f1
=10;
21 Statement Executed
: Rows Affected
= 4
22 echo select * from t1
;
23 ---------------------------------------------------------
25 ---------------------------------------------------------
31 echo update t1
set f2
='hello';
32 Statement Executed
: Rows Affected
= 4
33 echo select * from t1
;
34 ---------------------------------------------------------
36 ---------------------------------------------------------
42 echo update t1
set f3
=10000;
43 Statement Executed
: Rows Affected
= 4
44 echo select * from t1
;
45 ---------------------------------------------------------
47 ---------------------------------------------------------
53 echo create table t2
(f1 tinyint
, f2 float
);
55 echo insert into t2 values
(112, 235.50);
56 Statement Executed
: Rows Affected
= 1
57 echo insert into t2
(f1
) values
(220);
58 Statement Executed
: Rows Affected
= 1
59 echo insert into t2
(f2
) values
(100.50);
60 Statement Executed
: Rows Affected
= 1
61 echo select * from t2
;
62 ---------------------------------------------------------
64 ---------------------------------------------------------
69 echo update t2
set f2
=250.50;
70 Statement Executed
: Rows Affected
= 3
71 echo update t2
set f1
=125;
72 Statement Executed
: Rows Affected
= 3
73 echo select * from t2
;
74 ---------------------------------------------------------
76 ---------------------------------------------------------