1 echo smallint data
type testing
;
3 Statement Executed
: Rows Affected
= 1
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 echo select * from t1
;
11 ---------------------------------------------------------
13 ---------------------------------------------------------
22 echo select * from t1 where f1
= 10;
23 ---------------------------------------------------------
25 ---------------------------------------------------------
28 echo select * from t1 where f1
!= 12 AND f2
<= 13;
29 ---------------------------------------------------------
31 ---------------------------------------------------------
38 echo select * from t1 where f1
= 12 AND f2
>= 22;
39 ---------------------------------------------------------
41 ---------------------------------------------------------
43 echo select * from t1 where f1
= 12 OR f2
< 13;
44 ---------------------------------------------------------
46 ---------------------------------------------------------
54 echo select * from t1 where f1
= 12 OR f2
<> 22;
55 ---------------------------------------------------------
57 ---------------------------------------------------------
66 echo select * from t1 where NOT f1
= 12;
67 ---------------------------------------------------------
69 ---------------------------------------------------------
77 echo select * from t1 where f1
!= 12;
78 ---------------------------------------------------------
80 ---------------------------------------------------------
88 echo select * from t1 where NOT f1
!= 12;
89 ---------------------------------------------------------
91 ---------------------------------------------------------
94 echo select * from t1 where f1
= f2
;
95 ---------------------------------------------------------
97 ---------------------------------------------------------
99 echo select * from t1 where f1 between
9997 and
9999;
100 ---------------------------------------------------------
102 ---------------------------------------------------------
105 echo select * from t1 where f1 between
-9999 and
-9997;
106 ---------------------------------------------------------
108 ---------------------------------------------------------
111 echo update t1
set f2
= 2 where f1
!= f2
;
112 Statement Executed
: Rows Affected
= 7
113 ---------------------------------------------------------
115 ---------------------------------------------------------
124 echo update t1
set f2
= 3 where f1
= 50;
125 Statement Executed
: Rows Affected
= 1
126 ---------------------------------------------------------
128 ---------------------------------------------------------
137 Statement Executed
: Rows Affected
= 1
138 ---------------------------------------------------------
140 ---------------------------------------------------------