1 echo create table t1
(f1 int
, f2 int
,f3 int
);
3 echo insert into t1 values
(10,10,10);
4 Statement Executed
: Rows Affected
= 1
5 echo insert into t1 values
(20,10,10);
6 Statement Executed
: Rows Affected
= 1
7 echo insert into t1 values
(30,10,10);
8 Statement Executed
: Rows Affected
= 1
9 echo insert into t1 values
(40,10,10);
10 Statement Executed
: Rows Affected
= 1
11 echo insert into t1 values
(50,10,10);
12 Statement Executed
: Rows Affected
= 1
13 echo insert into t1 values
(60,10,10);
14 Statement Executed
: Rows Affected
= 1
15 echo select * from t1
;
16 ---------------------------------------------------------
18 ---------------------------------------------------------
26 echo update t1
set f1
=f1
+f2
+f3
+7,f2
=f3
+23+f1
,f3
=12;
27 Statement Executed
: Rows Affected
= 6
28 echo select * from t1
;
29 ---------------------------------------------------------
31 ---------------------------------------------------------
39 echo update t1
set f1
=f
2/f3
+7,f2
=f3
+23+f1
,f3
=f2 where f3
=12;
40 Statement Executed
: Rows Affected
= 6
41 echo select * from t1
;
42 ---------------------------------------------------------
44 ---------------------------------------------------------
52 echo create table t2
(f1 tinyint
, f2 bigint
,f3 int
);
54 echo insert into t2 values
(60,1110,5110);
55 Statement Executed
: Rows Affected
= 1
56 echo insert into t2 values
(70,1115,1510);
57 Statement Executed
: Rows Affected
= 1
58 echo insert into t2 values
(80,1150,1150);
59 Statement Executed
: Rows Affected
= 1
60 echo insert into t2 values
(90,1510,1115);
61 Statement Executed
: Rows Affected
= 1
62 echo insert into t2 values
(50,5110,1110);
63 Statement Executed
: Rows Affected
= 1
64 echo select * from t2
;
65 ---------------------------------------------------------
67 ---------------------------------------------------------
74 echo update t2
set f1
=NULL
,f2
=f1
+f2
+f3
+10 where f2
>1122;
75 Statement Executed
: Rows Affected
= 3
76 echo select * from t2
;
77 ---------------------------------------------------------
79 ---------------------------------------------------------
86 echo update t2
set f2
=f2
+123 ,f3
=23+f2
;
87 Statement Executed
: Rows Affected
= 5
88 echo select * from t2
;
89 ---------------------------------------------------------
91 ---------------------------------------------------------