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
9 Statement Executed
: Rows Affected
= 1
10 Statement Executed
: Rows Affected
= 1
11 Statement execute failed with error
-21
12 echo select * from t1
;
13 ---------------------------------------------------------
15 ---------------------------------------------------------
25 echo select count
(*) from t1
;
26 ---------------------------------------------------------
28 ---------------------------------------------------------
31 echo select count
(f1
) from t1
;
32 ---------------------------------------------------------
34 ---------------------------------------------------------
37 echo select count
(f2
) from t1
;
38 ---------------------------------------------------------
40 ---------------------------------------------------------
43 echo select * from t1 where f1
=11;
44 ---------------------------------------------------------
46 ---------------------------------------------------------
49 echo select count
(*) from t1 where f1
= 11;
50 ---------------------------------------------------------
52 ---------------------------------------------------------
55 echo select count
(f1
) from t1 where f1
=20;
56 ---------------------------------------------------------
58 ---------------------------------------------------------
61 echo select count
(f2
) from t1 where f2
=500;
62 ---------------------------------------------------------
64 ---------------------------------------------------------
67 echo select * from t1
;
68 ---------------------------------------------------------
70 ---------------------------------------------------------
80 echo select min
(f1
) from t1
;
81 ---------------------------------------------------------
83 ---------------------------------------------------------
86 echo select min
(f2
) from t1
;
87 ---------------------------------------------------------
89 ---------------------------------------------------------
92 echo select min
(f1
) from t1 where f1
=20;
93 ---------------------------------------------------------
95 ---------------------------------------------------------
98 echo select min
(f2
) from t1 where f2
=500;
99 ---------------------------------------------------------
101 ---------------------------------------------------------
104 echo select * from t1
;
105 ---------------------------------------------------------
107 ---------------------------------------------------------
117 echo select max
(f1
) from t1
;
118 ---------------------------------------------------------
120 ---------------------------------------------------------
123 echo select max
(f2
) from t1
;
124 ---------------------------------------------------------
126 ---------------------------------------------------------
129 echo select max
(f1
) from t1 where f1
=20;
130 ---------------------------------------------------------
132 ---------------------------------------------------------
135 echo select max
(f2
) from t1 where f2
=500;
136 ---------------------------------------------------------
138 ---------------------------------------------------------
141 echo select * from t1
;
142 ---------------------------------------------------------
144 ---------------------------------------------------------
154 echo select avg
(f1
) from t1
;
155 ---------------------------------------------------------
157 ---------------------------------------------------------
160 echo select avg
(f2
) from t1
;
161 ---------------------------------------------------------
163 ---------------------------------------------------------
166 echo select avg
(f1
) from t1 where f1
=20;
167 ---------------------------------------------------------
169 ---------------------------------------------------------
172 echo select avg
(f2
) from t1 where f2
=500;
173 ---------------------------------------------------------
175 ---------------------------------------------------------
178 echo select * from t1
;
179 ---------------------------------------------------------
181 ---------------------------------------------------------
191 echo select sum(f1
) from t1
;
192 ---------------------------------------------------------
194 ---------------------------------------------------------
197 echo select sum(f2
) from t1
;
198 ---------------------------------------------------------
200 ---------------------------------------------------------
203 echo select sum(f1
) from t1 where f1
=20;
204 ---------------------------------------------------------
206 ---------------------------------------------------------
209 echo select sum(f2
) from t1 where f2
=500;
210 ---------------------------------------------------------
212 ---------------------------------------------------------