1 echo Same as csql2 but with primary key
;
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
= 100;
21 ---------------------------------------------------------
23 ---------------------------------------------------------
25 echo select * from t1 where f1
= 10;
26 ---------------------------------------------------------
28 ---------------------------------------------------------
31 echo select f1 from t1 where f1
= 11;
32 ---------------------------------------------------------
34 ---------------------------------------------------------
37 echo select f2 from t1 where f1
= 11;
38 ---------------------------------------------------------
40 ---------------------------------------------------------
43 echo select f1
, f2 from t1 where f1
= 12;
44 ---------------------------------------------------------
46 ---------------------------------------------------------
49 echo select * from t1 where f1
!= 12 AND f2
<= 13;
50 ---------------------------------------------------------
52 ---------------------------------------------------------
54 echo select * from t1 where f1
= 12 AND f2
>= 22;
55 ---------------------------------------------------------
57 ---------------------------------------------------------
60 echo select * from t1 where f1
= 12 OR f1
> 13;
61 ---------------------------------------------------------
63 ---------------------------------------------------------
68 echo select * from t1 where f1
= 12 OR f2
< 13;
69 ---------------------------------------------------------
71 ---------------------------------------------------------
74 echo select * from t1 where f1
= 12 OR f2
<> 22;
75 ---------------------------------------------------------
77 ---------------------------------------------------------
85 echo select * from t1 where NOT f1
= 12;
86 ---------------------------------------------------------
88 ---------------------------------------------------------
95 echo select * from t1 where f1
!= 12;
96 ---------------------------------------------------------
98 ---------------------------------------------------------
105 echo select * from t1 where NOT f1
!= 12;
106 ---------------------------------------------------------
108 ---------------------------------------------------------
111 echo select * from t1 where NOT
(f1
= 12 AND f2
=22);
112 ---------------------------------------------------------
114 ---------------------------------------------------------
121 echo select * from t1 where NOT
(f1
= 12 OR f2
= 23);
122 ---------------------------------------------------------
124 ---------------------------------------------------------
130 echo select * from t1 where f1
= 12 OR f2
= 23 OR f2
= 22;
131 ---------------------------------------------------------
133 ---------------------------------------------------------
137 echo select * from t1 where f1
+12 = 20;
138 Statement prepare failed with error
-19
139 echo select * from t1 where f1
= 12 + f2
;
140 Statement prepare failed with error
-19
141 echo select * from t1 where f1
= f2
;
142 ---------------------------------------------------------
144 ---------------------------------------------------------
147 echo select * from t1 where f1
=12 and f1
<=13 or f1
>=11;
148 ---------------------------------------------------------
150 ---------------------------------------------------------