2 echo Same as csql2 but with primary key
;
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
= 100;
22 ---------------------------------------------------------
24 ---------------------------------------------------------
26 echo select * from t1 where f1
= 10;
27 ---------------------------------------------------------
29 ---------------------------------------------------------
32 echo select f1 from t1 where f1
= 11;
33 ---------------------------------------------------------
35 ---------------------------------------------------------
38 echo select f2 from t1 where f1
= 11;
39 ---------------------------------------------------------
41 ---------------------------------------------------------
44 echo select f1
, f2 from t1 where f1
= 12;
45 ---------------------------------------------------------
47 ---------------------------------------------------------
50 echo select * from t1 where f1
!= 12 AND f2
<= 13;
51 ---------------------------------------------------------
53 ---------------------------------------------------------
55 echo select * from t1 where f1
= 12 AND f2
>= 22;
56 ---------------------------------------------------------
58 ---------------------------------------------------------
61 echo select * from t1 where f1
= 12 OR f1
> 13;
62 ---------------------------------------------------------
64 ---------------------------------------------------------
69 echo select * from t1 where f1
= 12 OR f2
< 13;
70 ---------------------------------------------------------
72 ---------------------------------------------------------
75 echo select * from t1 where f1
= 12 OR f2
<> 22;
76 ---------------------------------------------------------
78 ---------------------------------------------------------
86 echo select * from t1 where NOT f1
= 12;
87 ---------------------------------------------------------
89 ---------------------------------------------------------
96 echo select * from t1 where f1
!= 12;
97 ---------------------------------------------------------
99 ---------------------------------------------------------
106 echo select * from t1 where NOT f1
!= 12;
107 ---------------------------------------------------------
109 ---------------------------------------------------------
112 echo select * from t1 where NOT
(f1
= 12 AND f2
=22);
113 ---------------------------------------------------------
115 ---------------------------------------------------------
122 echo select * from t1 where NOT
(f1
= 12 OR f2
= 23);
123 ---------------------------------------------------------
125 ---------------------------------------------------------
131 echo select * from t1 where f1
= 12 OR f2
= 23 OR f2
= 22;
132 ---------------------------------------------------------
134 ---------------------------------------------------------
138 echo select * from t1 where f1
+12 = 20;
139 Statement prepare failed with error
-19
140 echo select * from t1 where f1
= 12 + f2
;
141 Statement prepare failed with error
-19
142 echo select * from t1 where f1
= f2
;
143 ---------------------------------------------------------
145 ---------------------------------------------------------
148 echo select * from t1 where f1
=12 and f1
<=13 or f1
>=11;
149 ---------------------------------------------------------
151 ---------------------------------------------------------