2 echo char datatype 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 Statement Executed
: Rows Affected
= 1
12 Statement Executed
: Rows Affected
= 1
13 Statement Executed
: Rows Affected
= 1
14 Statement Executed
: Rows Affected
= 1
15 echo select * from t1
;
16 ---------------------------------------------------------
18 ---------------------------------------------------------
31 echo select * from t1 where f1
= '10';
32 ---------------------------------------------------------
34 ---------------------------------------------------------
37 echo select * from t1 where f1
!= '12' AND f2
<= '13';
38 ---------------------------------------------------------
40 ---------------------------------------------------------
42 echo select * from t1 where f1
= '12' AND f2
>= '22';
43 ---------------------------------------------------------
45 ---------------------------------------------------------
48 echo select * from t1 where f1
= '12' OR f1
> '13';
49 ---------------------------------------------------------
51 ---------------------------------------------------------
61 echo select * from t1 where f1
= '12' OR f2
= '13';
62 ---------------------------------------------------------
64 ---------------------------------------------------------
67 echo select * from t1 where f1
= '12' OR f2
< '22';
68 ---------------------------------------------------------
70 ---------------------------------------------------------
83 echo select * from t1 where NOT f1
= '12';
84 ---------------------------------------------------------
86 ---------------------------------------------------------
98 echo select * from t1 where f1
!= '12';
99 ---------------------------------------------------------
101 ---------------------------------------------------------
107 This is really a ve E
111 uppercaseletter LOWER
113 echo select * from t1 where NOT f1
!= '12';
114 ---------------------------------------------------------
116 ---------------------------------------------------------
119 echo select * from t1 where f1
= f2
;
120 ---------------------------------------------------------
122 ---------------------------------------------------------
125 echo select * from t1 where f2 between
'A' AND
'C';
126 ---------------------------------------------------------
128 ---------------------------------------------------------
133 echo update t1
set f2
= '2' where f1
!= f2
;
134 Statement Executed
: Rows Affected
= 10
135 ---------------------------------------------------------
137 ---------------------------------------------------------
144 This is really a ve
2
150 echo update t1
set f2
= '3' where f1
= '50';
151 Statement Executed
: Rows Affected
= 1
152 ---------------------------------------------------------
154 ---------------------------------------------------------
161 This is really a ve
2
167 Statement Executed
: Rows Affected
= 1
168 ---------------------------------------------------------
170 ---------------------------------------------------------
176 This is really a ve
2