2 echo smallint data
type testing
;
4 Statement Executed
: Rows Affected
= 1
5 Statement Executed
: Rows Affected
= 1
6 Statement Executed
: Rows Affected
= 1
7 Statement Executed
: Rows Affected
= 1
8 Statement Executed
: Rows Affected
= 1
9 Statement Executed
: Rows Affected
= 1
10 Statement Executed
: Rows Affected
= 1
11 echo select * from t1
;
12 ---------------------------------------------------------
14 ---------------------------------------------------------
23 echo select * from t1 where f1
= 10;
24 ---------------------------------------------------------
26 ---------------------------------------------------------
29 echo select * from t1 where f1
!= 12 AND f2
<= 13;
30 ---------------------------------------------------------
32 ---------------------------------------------------------
39 echo select * from t1 where f1
= 12 AND f2
>= 22;
40 ---------------------------------------------------------
42 ---------------------------------------------------------
44 echo select * from t1 where f1
= 12 OR f2
< 13;
45 ---------------------------------------------------------
47 ---------------------------------------------------------
55 echo select * from t1 where f1
= 12 OR f2
<> 22;
56 ---------------------------------------------------------
58 ---------------------------------------------------------
67 echo select * from t1 where NOT f1
= 12;
68 ---------------------------------------------------------
70 ---------------------------------------------------------
78 echo select * from t1 where f1
!= 12;
79 ---------------------------------------------------------
81 ---------------------------------------------------------
89 echo select * from t1 where NOT f1
!= 12;
90 ---------------------------------------------------------
92 ---------------------------------------------------------
95 echo select * from t1 where f1
= f2
;
96 ---------------------------------------------------------
98 ---------------------------------------------------------
100 echo select * from t1 where f1 between
9997 and
9999;
101 ---------------------------------------------------------
103 ---------------------------------------------------------
106 echo select * from t1 where f1 between
-9999 and
-9997;
107 ---------------------------------------------------------
109 ---------------------------------------------------------
112 echo update t1
set f2
= 2 where f1
!= f2
;
113 Statement Executed
: Rows Affected
= 7
114 ---------------------------------------------------------
116 ---------------------------------------------------------
125 echo update t1
set f2
= 3 where f1
= 50;
126 Statement Executed
: Rows Affected
= 1
127 ---------------------------------------------------------
129 ---------------------------------------------------------
138 Statement Executed
: Rows Affected
= 1
139 ---------------------------------------------------------
141 ---------------------------------------------------------