2 echo tinyint 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 echo select * from t1
;
11 ---------------------------------------------------------
13 ---------------------------------------------------------
21 echo select * from t1 where f1
= 10;
22 ---------------------------------------------------------
24 ---------------------------------------------------------
27 echo select * from t1 where f1
!= 12 AND f2
<= 13;
28 ---------------------------------------------------------
30 ---------------------------------------------------------
37 echo select * from t1 where f1
= 12 AND f2
>= 22;
38 ---------------------------------------------------------
40 ---------------------------------------------------------
42 echo select * from t1 where f1
= 12 OR f1
> 13;
43 ---------------------------------------------------------
45 ---------------------------------------------------------
49 echo select * from t1 where f1
= 12 OR f2
< 13;
50 ---------------------------------------------------------
52 ---------------------------------------------------------
60 echo select * from t1 where f1
= 12 OR f2
<> 22;
61 ---------------------------------------------------------
63 ---------------------------------------------------------
71 echo select * from t1 where NOT f1
= 12;
72 ---------------------------------------------------------
74 ---------------------------------------------------------
81 echo select * from t1 where f1
!= 12;
82 ---------------------------------------------------------
84 ---------------------------------------------------------
91 echo select * from t1 where NOT f1
!= 12;
92 ---------------------------------------------------------
94 ---------------------------------------------------------
97 echo select * from t1 where f1
= f2
;
98 ---------------------------------------------------------
100 ---------------------------------------------------------
102 echo select * from t1 where f1 between
126 and
127;
103 ---------------------------------------------------------
105 ---------------------------------------------------------
108 echo select * from t1 where f1 between
-127 and
-128;
109 ---------------------------------------------------------
111 ---------------------------------------------------------
113 echo update t1
set f2
= 2 where f1
!= f2
;
114 Statement Executed
: Rows Affected
= 6
115 ---------------------------------------------------------
117 ---------------------------------------------------------
125 echo update t1
set f2
= 3 where f1
= 12;
126 Statement Executed
: Rows Affected
= 1
127 ---------------------------------------------------------
129 ---------------------------------------------------------
137 Statement Executed
: Rows Affected
= 1
138 ---------------------------------------------------------
140 ---------------------------------------------------------