1 echo tinyint 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
10 ---------------------------------------------------------
12 ---------------------------------------------------------
20 echo select * from t1 where f1
= 10;
21 ---------------------------------------------------------
23 ---------------------------------------------------------
26 echo select * from t1 where f1
!= 12 AND f2
<= 13;
27 ---------------------------------------------------------
29 ---------------------------------------------------------
36 echo select * from t1 where f1
= 12 AND f2
>= 22;
37 ---------------------------------------------------------
39 ---------------------------------------------------------
41 echo select * from t1 where f1
= 12 OR f1
> 13;
42 ---------------------------------------------------------
44 ---------------------------------------------------------
48 echo select * from t1 where f1
= 12 OR f2
< 13;
49 ---------------------------------------------------------
51 ---------------------------------------------------------
59 echo select * from t1 where f1
= 12 OR f2
<> 22;
60 ---------------------------------------------------------
62 ---------------------------------------------------------
70 echo select * from t1 where NOT f1
= 12;
71 ---------------------------------------------------------
73 ---------------------------------------------------------
80 echo select * from t1 where f1
!= 12;
81 ---------------------------------------------------------
83 ---------------------------------------------------------
90 echo select * from t1 where NOT f1
!= 12;
91 ---------------------------------------------------------
93 ---------------------------------------------------------
96 echo select * from t1 where f1
= f2
;
97 ---------------------------------------------------------
99 ---------------------------------------------------------
101 echo select * from t1 where f1 between
126 and
127;
102 ---------------------------------------------------------
104 ---------------------------------------------------------
107 echo select * from t1 where f1 between
-127 and
-128;
108 ---------------------------------------------------------
110 ---------------------------------------------------------
112 echo update t1
set f2
= 2 where f1
!= f2
;
113 Statement Executed
: Rows Affected
= 6
114 ---------------------------------------------------------
116 ---------------------------------------------------------
124 echo update t1
set f2
= 3 where f1
= 12;
125 Statement Executed
: Rows Affected
= 1
126 ---------------------------------------------------------
128 ---------------------------------------------------------
136 Statement Executed
: Rows Affected
= 1
137 ---------------------------------------------------------
139 ---------------------------------------------------------