4 echo CREATE TABLE T1
(f1 INT
,f2 BIGINT
,f3 SMALLINT
, f4 FLOAT
, f5 CHAR
(10), PRIMARY KEY
(f2
, f3
, f1
));
6 echo CREATE TABLE T2
(f1 INT
,f2 BIGINT
,f3 SMALLINT
, f4 FLOAT
, f5 CHAR
(10), PRIMARY KEY
(f2
, f3
, f1
));
8 echo CREATE TABLE T3
(f1 INT
,f2 BIGINT
,f3 SMALLINT
, f4 FLOAT
, f5 CHAR
(10), PRIMARY KEY
(f2
, f3
, f1
));
10 echo CREATE TABLE T4
(f1 INT
,f2 BIGINT
,f3 SMALLINT
, f4 FLOAT
, f5 CHAR
(10), PRIMARY KEY
(f2
, f3
, f1
));
12 echo CREATE TABLE T5
(f1 INT
,f2 BIGINT
,f3 SMALLINT
, f4 FLOAT
, f5 CHAR
(10), PRIMARY KEY
(f2
, f3
, f1
));
14 echo CREATE TABLE T6
(f1 INT
,f2 BIGINT
,f3 SMALLINT
, f4 FLOAT
, f5 CHAR
(10), PRIMARY KEY
(f2
, f3
, f1
));
16 echo CREATE TABLE T7
(f1 INT
,f2 BIGINT
,f3 SMALLINT
, f4 FLOAT
, f5 CHAR
(10), PRIMARY KEY
(f2
, f3
, f1
));
18 echo CREATE TABLE T8
(f1 INT
,f2 BIGINT
,f3 SMALLINT
, f4 FLOAT
, f5 CHAR
(10), PRIMARY KEY
(f2
, f3
, f1
));
20 echo CREATE TABLE T9
(f1 INT
,f2 BIGINT
,f3 SMALLINT
, f4 FLOAT
, f5 CHAR
(10), PRIMARY KEY
(f2
, f3
, f1
));
22 echo CREATE TABLE T10
(f1 INT
,f2 BIGINT
,f3 SMALLINT
, f4 FLOAT
, f5 CHAR
(10), PRIMARY KEY
(f2
, f3
, f1
));
25 =============TableNames
===================
36 ==========================================
42 echo INSERT INTO T1 VALUES
(1, 10, 101, 101.101, 'Lakshya');
43 Statement Executed
: Rows Affected
= 1
44 echo INSERT INTO T1 VALUES
(1, 11, 101, 101.101, 'LAKSHYA');
45 Statement Executed
: Rows Affected
= 1
46 echo INSERT INTO T1 VALUES
(1, 11, 111, 101.101, 'LAKSHYA');
47 Statement Executed
: Rows Affected
= 1
48 echo INSERT INTO T1 VALUES
(1, 11, 101, 101.101, 'LAKSHYA');
49 Statement execute failed with error
-21
50 echo INSERT INTO T1 VALUES
(2, 20, 201, 101.101, 'Lakshya');
51 Statement Executed
: Rows Affected
= 1
52 echo INSERT INTO T1 VALUES
(2, 21, 201, 101.101, 'LAKSHYA');
53 Statement Executed
: Rows Affected
= 1
54 echo INSERT INTO T1 VALUES
(2, 21, 211, 101.101, 'LAKSHYA');
55 Statement Executed
: Rows Affected
= 1
56 echo INSERT INTO T1 VALUES
(2, 21, 201, 101.101, 'LAKSHYA');
57 Statement execute failed with error
-21
58 echo INSERT INTO T2 VALUES
(1, 10, 101, 101.101, 'Lakshya');
59 Statement Executed
: Rows Affected
= 1
60 echo INSERT INTO T2 VALUES
(1, 11, 101, 101.101, 'LAKSHYA');
61 Statement Executed
: Rows Affected
= 1
62 echo INSERT INTO T2 VALUES
(1, 11, 111, 101.101, 'LAKSHYA');
63 Statement Executed
: Rows Affected
= 1
64 echo INSERT INTO T2 VALUES
(1, 11, 101, 101.101, 'LAKSHYA');
65 Statement execute failed with error
-21
66 echo INSERT INTO T2 VALUES
(2, 20, 201, 101.101, 'Lakshya');
67 Statement Executed
: Rows Affected
= 1
68 echo INSERT INTO T2 VALUES
(2, 21, 201, 101.101, 'LAKSHYA');
69 Statement Executed
: Rows Affected
= 1
70 echo INSERT INTO T2 VALUES
(2, 21, 211, 101.101, 'LAKSHYA');
71 Statement Executed
: Rows Affected
= 1
72 echo INSERT INTO T2 VALUES
(2, 21, 201, 101.101, 'LAKSHYA');
73 Statement execute failed with error
-21
74 echo INSERT INTO T3 VALUES
(1, 10, 101, 101.101, 'Lakshya');
75 Statement Executed
: Rows Affected
= 1
76 echo INSERT INTO T3 VALUES
(1, 11, 101, 101.101, 'LAKSHYA');
77 Statement Executed
: Rows Affected
= 1
78 echo INSERT INTO T3 VALUES
(1, 11, 111, 101.101, 'LAKSHYA');
79 Statement Executed
: Rows Affected
= 1
80 echo INSERT INTO T3 VALUES
(1, 11, 101, 101.101, 'LAKSHYA');
81 Statement execute failed with error
-21
82 echo INSERT INTO T3 VALUES
(2, 20, 201, 101.101, 'Lakshya');
83 Statement Executed
: Rows Affected
= 1
84 echo INSERT INTO T3 VALUES
(2, 21, 201, 101.101, 'LAKSHYA');
85 Statement Executed
: Rows Affected
= 1
86 echo INSERT INTO T3 VALUES
(2, 21, 211, 101.101, 'LAKSHYA');
87 Statement Executed
: Rows Affected
= 1
88 echo INSERT INTO T3 VALUES
(2, 21, 201, 101.101, 'LAKSHYA');
89 Statement execute failed with error
-21
90 echo INSERT INTO T4 VALUES
(1, 10, 101, 101.101, 'Lakshya');
91 Statement Executed
: Rows Affected
= 1
92 echo INSERT INTO T4 VALUES
(1, 11, 101, 101.101, 'LAKSHYA');
93 Statement Executed
: Rows Affected
= 1
94 echo INSERT INTO T4 VALUES
(1, 11, 111, 101.101, 'LAKSHYA');
95 Statement Executed
: Rows Affected
= 1
96 echo INSERT INTO T4 VALUES
(1, 11, 101, 101.101, 'LAKSHYA');
97 Statement execute failed with error
-21
98 echo INSERT INTO T4 VALUES
(2, 20, 201, 101.101, 'Lakshya');
99 Statement Executed
: Rows Affected
= 1
100 echo INSERT INTO T4 VALUES
(2, 21, 201, 101.101, 'LAKSHYA');
101 Statement Executed
: Rows Affected
= 1
102 echo INSERT INTO T4 VALUES
(2, 21, 211, 101.101, 'LAKSHYA');
103 Statement Executed
: Rows Affected
= 1
104 echo INSERT INTO T4 VALUES
(2, 21, 201, 101.101, 'LAKSHYA');
105 Statement execute failed with error
-21
106 echo INSERT INTO T5 VALUES
(1, 10, 101, 101.101, 'Lakshya');
107 Statement Executed
: Rows Affected
= 1
108 echo INSERT INTO T5 VALUES
(1, 11, 101, 101.101, 'LAKSHYA');
109 Statement Executed
: Rows Affected
= 1
110 echo INSERT INTO T5 VALUES
(1, 11, 111, 101.101, 'LAKSHYA');
111 Statement Executed
: Rows Affected
= 1
112 echo INSERT INTO T5 VALUES
(1, 11, 101, 101.101, 'LAKSHYA');
113 Statement execute failed with error
-21
114 echo INSERT INTO T5 VALUES
(2, 20, 201, 101.101, 'Lakshya');
115 Statement Executed
: Rows Affected
= 1
116 echo INSERT INTO T5 VALUES
(2, 21, 201, 101.101, 'LAKSHYA');
117 Statement Executed
: Rows Affected
= 1
118 echo INSERT INTO T5 VALUES
(2, 21, 211, 101.101, 'LAKSHYA');
119 Statement Executed
: Rows Affected
= 1
120 echo INSERT INTO T5 VALUES
(2, 21, 201, 101.101, 'LAKSHYA');
121 Statement execute failed with error
-21
122 echo INSERT INTO T6 VALUES
(1, 10, 101, 101.101, 'Lakshya');
123 Statement Executed
: Rows Affected
= 1
124 echo INSERT INTO T6 VALUES
(1, 11, 101, 101.101, 'LAKSHYA');
125 Statement Executed
: Rows Affected
= 1
126 echo INSERT INTO T6 VALUES
(1, 11, 111, 101.101, 'LAKSHYA');
127 Statement Executed
: Rows Affected
= 1
128 echo INSERT INTO T6 VALUES
(1, 11, 101, 101.101, 'LAKSHYA');
129 Statement execute failed with error
-21
130 echo INSERT INTO T6 VALUES
(2, 20, 201, 101.101, 'Lakshya');
131 Statement Executed
: Rows Affected
= 1
132 echo INSERT INTO T6 VALUES
(2, 21, 201, 101.101, 'LAKSHYA');
133 Statement Executed
: Rows Affected
= 1
134 echo INSERT INTO T6 VALUES
(2, 21, 211, 101.101, 'LAKSHYA');
135 Statement Executed
: Rows Affected
= 1
136 echo INSERT INTO T6 VALUES
(2, 21, 201, 101.101, 'LAKSHYA');
137 Statement execute failed with error
-21
138 echo INSERT INTO T7 VALUES
(1, 10, 101, 101.101, 'Lakshya');
139 Statement Executed
: Rows Affected
= 1
140 echo INSERT INTO T7 VALUES
(1, 11, 101, 101.101, 'LAKSHYA');
141 Statement Executed
: Rows Affected
= 1
142 echo INSERT INTO T7 VALUES
(1, 11, 111, 101.101, 'LAKSHYA');
143 Statement Executed
: Rows Affected
= 1
144 echo INSERT INTO T7 VALUES
(1, 11, 101, 101.101, 'LAKSHYA');
145 Statement execute failed with error
-21
146 echo INSERT INTO T7 VALUES
(2, 20, 201, 101.101, 'Lakshya');
147 Statement Executed
: Rows Affected
= 1
148 echo INSERT INTO T7 VALUES
(2, 21, 201, 101.101, 'LAKSHYA');
149 Statement Executed
: Rows Affected
= 1
150 echo INSERT INTO T7 VALUES
(2, 21, 211, 101.101, 'LAKSHYA');
151 Statement Executed
: Rows Affected
= 1
152 echo INSERT INTO T7 VALUES
(2, 21, 201, 101.101, 'LAKSHYA');
153 Statement execute failed with error
-21
154 echo INSERT INTO T8 VALUES
(1, 10, 101, 101.101, 'Lakshya');
155 Statement Executed
: Rows Affected
= 1
156 echo INSERT INTO T8 VALUES
(1, 11, 101, 101.101, 'LAKSHYA');
157 Statement Executed
: Rows Affected
= 1
158 echo INSERT INTO T8 VALUES
(1, 11, 111, 101.101, 'LAKSHYA');
159 Statement Executed
: Rows Affected
= 1
160 echo INSERT INTO T8 VALUES
(1, 11, 101, 101.101, 'LAKSHYA');
161 Statement execute failed with error
-21
162 echo INSERT INTO T8 VALUES
(2, 20, 201, 101.101, 'Lakshya');
163 Statement Executed
: Rows Affected
= 1
164 echo INSERT INTO T8 VALUES
(2, 21, 201, 101.101, 'LAKSHYA');
165 Statement Executed
: Rows Affected
= 1
166 echo INSERT INTO T8 VALUES
(2, 21, 211, 101.101, 'LAKSHYA');
167 Statement Executed
: Rows Affected
= 1
168 echo INSERT INTO T8 VALUES
(2, 21, 201, 101.101, 'LAKSHYA');
169 Statement execute failed with error
-21
170 echo INSERT INTO T9 VALUES
(1, 10, 101, 101.101, 'Lakshya');
171 Statement Executed
: Rows Affected
= 1
172 echo INSERT INTO T9 VALUES
(1, 11, 101, 101.101, 'LAKSHYA');
173 Statement Executed
: Rows Affected
= 1
174 echo INSERT INTO T9 VALUES
(1, 11, 111, 101.101, 'LAKSHYA');
175 Statement Executed
: Rows Affected
= 1
176 echo INSERT INTO T9 VALUES
(1, 11, 101, 101.101, 'LAKSHYA');
177 Statement execute failed with error
-21
178 echo INSERT INTO T9 VALUES
(2, 20, 201, 101.101, 'Lakshya');
179 Statement Executed
: Rows Affected
= 1
180 echo INSERT INTO T9 VALUES
(2, 21, 201, 101.101, 'LAKSHYA');
181 Statement Executed
: Rows Affected
= 1
182 echo INSERT INTO T9 VALUES
(2, 21, 211, 101.101, 'LAKSHYA');
183 Statement Executed
: Rows Affected
= 1
184 echo INSERT INTO T9 VALUES
(2, 21, 201, 101.101, 'LAKSHYA');
185 Statement execute failed with error
-21
186 echo INSERT INTO T10 VALUES
(1, 10, 101, 101.101, 'Lakshya');
187 Statement Executed
: Rows Affected
= 1
188 echo INSERT INTO T10 VALUES
(1, 11, 101, 101.101, 'LAKSHYA');
189 Statement Executed
: Rows Affected
= 1
190 echo INSERT INTO T10 VALUES
(1, 11, 111, 101.101, 'LAKSHYA');
191 Statement Executed
: Rows Affected
= 1
192 echo INSERT INTO T10 VALUES
(1, 11, 101, 101.101, 'LAKSHYA');
193 Statement execute failed with error
-21
194 echo INSERT INTO T10 VALUES
(2, 20, 201, 101.101, 'Lakshya');
195 Statement Executed
: Rows Affected
= 1
196 echo INSERT INTO T10 VALUES
(2, 21, 201, 101.101, 'LAKSHYA');
197 Statement Executed
: Rows Affected
= 1
198 echo INSERT INTO T10 VALUES
(2, 21, 211, 101.101, 'LAKSHYA');
199 Statement Executed
: Rows Affected
= 1
200 echo INSERT INTO T10 VALUES
(2, 21, 201, 101.101, 'LAKSHYA');
201 Statement execute failed with error
-21
202 echo SELECT
* FROM T1
;
203 ---------------------------------------------------------
204 T1.f1 T1.f2 T1.f3 T1.f4 T1.f5
205 ---------------------------------------------------------
206 1 10 101 101.100998 Lakshya
207 1 11 101 101.100998 LAKSHYA
208 1 11 111 101.100998 LAKSHYA
209 2 20 201 101.100998 Lakshya
210 2 21 201 101.100998 LAKSHYA
211 2 21 211 101.100998 LAKSHYA
213 echo SELECT
* FROM T2
;
214 ---------------------------------------------------------
215 T2.f1 T2.f2 T2.f3 T2.f4 T2.f5
216 ---------------------------------------------------------
217 1 10 101 101.100998 Lakshya
218 1 11 101 101.100998 LAKSHYA
219 1 11 111 101.100998 LAKSHYA
220 2 20 201 101.100998 Lakshya
221 2 21 201 101.100998 LAKSHYA
222 2 21 211 101.100998 LAKSHYA
224 echo SELECT
* FROM T3
;
225 ---------------------------------------------------------
226 T3.f1 T3.f2 T3.f3 T3.f4 T3.f5
227 ---------------------------------------------------------
228 1 10 101 101.100998 Lakshya
229 1 11 101 101.100998 LAKSHYA
230 1 11 111 101.100998 LAKSHYA
231 2 20 201 101.100998 Lakshya
232 2 21 201 101.100998 LAKSHYA
233 2 21 211 101.100998 LAKSHYA
235 echo SELECT
* FROM T4
;
236 ---------------------------------------------------------
237 T4.f1 T4.f2 T4.f3 T4.f4 T4.f5
238 ---------------------------------------------------------
239 1 10 101 101.100998 Lakshya
240 1 11 101 101.100998 LAKSHYA
241 1 11 111 101.100998 LAKSHYA
242 2 20 201 101.100998 Lakshya
243 2 21 201 101.100998 LAKSHYA
244 2 21 211 101.100998 LAKSHYA
246 echo SELECT
* FROM T5
;
247 ---------------------------------------------------------
248 T5.f1 T5.f2 T5.f3 T5.f4 T5.f5
249 ---------------------------------------------------------
250 1 10 101 101.100998 Lakshya
251 1 11 101 101.100998 LAKSHYA
252 1 11 111 101.100998 LAKSHYA
253 2 20 201 101.100998 Lakshya
254 2 21 201 101.100998 LAKSHYA
255 2 21 211 101.100998 LAKSHYA
257 echo SELECT
* FROM T6
;
258 ---------------------------------------------------------
259 T6.f1 T6.f2 T6.f3 T6.f4 T6.f5
260 ---------------------------------------------------------
261 1 10 101 101.100998 Lakshya
262 1 11 101 101.100998 LAKSHYA
263 1 11 111 101.100998 LAKSHYA
264 2 20 201 101.100998 Lakshya
265 2 21 201 101.100998 LAKSHYA
266 2 21 211 101.100998 LAKSHYA
268 echo SELECT
* FROM T7
;
269 ---------------------------------------------------------
270 T7.f1 T7.f2 T7.f3 T7.f4 T7.f5
271 ---------------------------------------------------------
272 1 10 101 101.100998 Lakshya
273 1 11 101 101.100998 LAKSHYA
274 1 11 111 101.100998 LAKSHYA
275 2 20 201 101.100998 Lakshya
276 2 21 201 101.100998 LAKSHYA
277 2 21 211 101.100998 LAKSHYA
279 echo SELECT
* FROM T8
;
280 ---------------------------------------------------------
281 T8.f1 T8.f2 T8.f3 T8.f4 T8.f5
282 ---------------------------------------------------------
283 1 10 101 101.100998 Lakshya
284 1 11 101 101.100998 LAKSHYA
285 1 11 111 101.100998 LAKSHYA
286 2 20 201 101.100998 Lakshya
287 2 21 201 101.100998 LAKSHYA
288 2 21 211 101.100998 LAKSHYA
290 echo SELECT
* FROM T9
;
291 ---------------------------------------------------------
292 T9.f1 T9.f2 T9.f3 T9.f4 T9.f5
293 ---------------------------------------------------------
294 1 10 101 101.100998 Lakshya
295 1 11 101 101.100998 LAKSHYA
296 1 11 111 101.100998 LAKSHYA
297 2 20 201 101.100998 Lakshya
298 2 21 201 101.100998 LAKSHYA
299 2 21 211 101.100998 LAKSHYA
301 echo SELECT
* FROM T10
;
302 ---------------------------------------------------------
303 T10.f1 T10.f2 T10.f3 T10.f4 T10.f5
304 ---------------------------------------------------------
305 1 10 101 101.100998 Lakshya
306 1 11 101 101.100998 LAKSHYA
307 1 11 111 101.100998 LAKSHYA
308 2 20 201 101.100998 Lakshya
309 2 21 201 101.100998 LAKSHYA
310 2 21 211 101.100998 LAKSHYA
316 UPDATING RECORDS IN TABLE
317 echo UPDATE T1 SET f4
= 20.02,f5
= 'Jagannath' WHERE f1
=2;
318 Statement Executed
: Rows Affected
= 3
319 echo UPDATE T1 SET f1
=3 WHERE f1
=2;
320 Statement prepare failed with error
-21
321 echo UPDATE T2 SET f4
= 20.02,f5
= 'Jagannath' WHERE f1
=2;
322 Statement Executed
: Rows Affected
= 3
323 echo UPDATE T2 SET f1
=3 WHERE f1
=2;
324 Statement prepare failed with error
-21
325 echo UPDATE T3 SET f4
= 20.02,f5
= 'Jagannath' WHERE f1
=2;
326 Statement Executed
: Rows Affected
= 3
327 echo UPDATE T3 SET f1
=3 WHERE f1
=2;
328 Statement prepare failed with error
-21
329 echo UPDATE T4 SET f4
= 20.02,f5
= 'Jagannath' WHERE f1
=2;
330 Statement Executed
: Rows Affected
= 3
331 echo UPDATE T4 SET f1
=3 WHERE f1
=2;
332 Statement prepare failed with error
-21
333 echo UPDATE T5 SET f4
= 20.02,f5
= 'Jagannath' WHERE f1
=2;
334 Statement Executed
: Rows Affected
= 3
335 echo UPDATE T5 SET f1
=3 WHERE f1
=2;
336 Statement prepare failed with error
-21
337 echo UPDATE T6 SET f4
= 20.02,f5
= 'Jagannath' WHERE f1
=2;
338 Statement Executed
: Rows Affected
= 3
339 echo UPDATE T6 SET f1
=3 WHERE f1
=2;
340 Statement prepare failed with error
-21
341 echo UPDATE T7 SET f4
= 20.02,f5
= 'Jagannath' WHERE f1
=2;
342 Statement Executed
: Rows Affected
= 3
343 echo UPDATE T7 SET f1
=3 WHERE f1
=2;
344 Statement prepare failed with error
-21
345 echo UPDATE T8 SET f4
= 20.02,f5
= 'Jagannath' WHERE f1
=2;
346 Statement Executed
: Rows Affected
= 3
347 echo UPDATE T8 SET f1
=3 WHERE f1
=2;
348 Statement prepare failed with error
-21
349 echo UPDATE T9 SET f4
= 20.02,f5
= 'Jagannath' WHERE f1
=2;
350 Statement Executed
: Rows Affected
= 3
351 echo UPDATE T9 SET f1
=3 WHERE f1
=2;
352 Statement prepare failed with error
-21
353 echo UPDATE T10 SET f4
= 20.02,f5
= 'Jagannath' WHERE f1
=2;
354 Statement Executed
: Rows Affected
= 3
355 echo UPDATE T10 SET f1
=3 WHERE f1
=2;
356 Statement prepare failed with error
-21
357 echo SELECT
* FROM T1
;
358 ---------------------------------------------------------
359 T1.f1 T1.f2 T1.f3 T1.f4 T1.f5
360 ---------------------------------------------------------
361 1 10 101 101.100998 Lakshya
362 1 11 101 101.100998 LAKSHYA
363 1 11 111 101.100998 LAKSHYA
364 2 20 201 20.020000 Jagannath
365 2 21 201 20.020000 Jagannath
366 2 21 211 20.020000 Jagannath
368 echo SELECT
* FROM T2
;
369 ---------------------------------------------------------
370 T2.f1 T2.f2 T2.f3 T2.f4 T2.f5
371 ---------------------------------------------------------
372 1 10 101 101.100998 Lakshya
373 1 11 101 101.100998 LAKSHYA
374 1 11 111 101.100998 LAKSHYA
375 2 20 201 20.020000 Jagannath
376 2 21 201 20.020000 Jagannath
377 2 21 211 20.020000 Jagannath
379 echo SELECT
* FROM T3
;
380 ---------------------------------------------------------
381 T3.f1 T3.f2 T3.f3 T3.f4 T3.f5
382 ---------------------------------------------------------
383 1 10 101 101.100998 Lakshya
384 1 11 101 101.100998 LAKSHYA
385 1 11 111 101.100998 LAKSHYA
386 2 20 201 20.020000 Jagannath
387 2 21 201 20.020000 Jagannath
388 2 21 211 20.020000 Jagannath
390 echo SELECT
* FROM T4
;
391 ---------------------------------------------------------
392 T4.f1 T4.f2 T4.f3 T4.f4 T4.f5
393 ---------------------------------------------------------
394 1 10 101 101.100998 Lakshya
395 1 11 101 101.100998 LAKSHYA
396 1 11 111 101.100998 LAKSHYA
397 2 20 201 20.020000 Jagannath
398 2 21 201 20.020000 Jagannath
399 2 21 211 20.020000 Jagannath
401 echo SELECT
* FROM T5
;
402 ---------------------------------------------------------
403 T5.f1 T5.f2 T5.f3 T5.f4 T5.f5
404 ---------------------------------------------------------
405 1 10 101 101.100998 Lakshya
406 1 11 101 101.100998 LAKSHYA
407 1 11 111 101.100998 LAKSHYA
408 2 20 201 20.020000 Jagannath
409 2 21 201 20.020000 Jagannath
410 2 21 211 20.020000 Jagannath
412 echo SELECT
* FROM T6
;
413 ---------------------------------------------------------
414 T6.f1 T6.f2 T6.f3 T6.f4 T6.f5
415 ---------------------------------------------------------
416 1 10 101 101.100998 Lakshya
417 1 11 101 101.100998 LAKSHYA
418 1 11 111 101.100998 LAKSHYA
419 2 20 201 20.020000 Jagannath
420 2 21 201 20.020000 Jagannath
421 2 21 211 20.020000 Jagannath
423 echo SELECT
* FROM T7
;
424 ---------------------------------------------------------
425 T7.f1 T7.f2 T7.f3 T7.f4 T7.f5
426 ---------------------------------------------------------
427 1 10 101 101.100998 Lakshya
428 1 11 101 101.100998 LAKSHYA
429 1 11 111 101.100998 LAKSHYA
430 2 20 201 20.020000 Jagannath
431 2 21 201 20.020000 Jagannath
432 2 21 211 20.020000 Jagannath
434 echo SELECT
* FROM T8
;
435 ---------------------------------------------------------
436 T8.f1 T8.f2 T8.f3 T8.f4 T8.f5
437 ---------------------------------------------------------
438 1 10 101 101.100998 Lakshya
439 1 11 101 101.100998 LAKSHYA
440 1 11 111 101.100998 LAKSHYA
441 2 20 201 20.020000 Jagannath
442 2 21 201 20.020000 Jagannath
443 2 21 211 20.020000 Jagannath
445 echo SELECT
* FROM T9
;
446 ---------------------------------------------------------
447 T9.f1 T9.f2 T9.f3 T9.f4 T9.f5
448 ---------------------------------------------------------
449 1 10 101 101.100998 Lakshya
450 1 11 101 101.100998 LAKSHYA
451 1 11 111 101.100998 LAKSHYA
452 2 20 201 20.020000 Jagannath
453 2 21 201 20.020000 Jagannath
454 2 21 211 20.020000 Jagannath
456 echo SELECT
* FROM T10
;
457 ---------------------------------------------------------
458 T10.f1 T10.f2 T10.f3 T10.f4 T10.f5
459 ---------------------------------------------------------
460 1 10 101 101.100998 Lakshya
461 1 11 101 101.100998 LAKSHYA
462 1 11 111 101.100998 LAKSHYA
463 2 20 201 20.020000 Jagannath
464 2 21 201 20.020000 Jagannath
465 2 21 211 20.020000 Jagannath
471 DELETING RECORDS FROM TABLE
472 echo DELETE FROM T1 WHERE f1
= 1;
473 Statement Executed
: Rows Affected
= 3
474 echo DELETE FROM T2 WHERE f1
= 1;
475 Statement Executed
: Rows Affected
= 3
476 echo DELETE FROM T3 WHERE f1
= 1;
477 Statement Executed
: Rows Affected
= 3
478 echo DELETE FROM T4 WHERE f1
= 1;
479 Statement Executed
: Rows Affected
= 3
480 echo DELETE FROM T5 WHERE f1
= 1;
481 Statement Executed
: Rows Affected
= 3
482 echo DELETE FROM T6 WHERE f1
= 1;
483 Statement Executed
: Rows Affected
= 3
484 echo DELETE FROM T7 WHERE f1
= 1;
485 Statement Executed
: Rows Affected
= 3
486 echo DELETE FROM T8 WHERE f1
= 1;
487 Statement Executed
: Rows Affected
= 3
488 echo DELETE FROM T9 WHERE f1
= 1;
489 Statement Executed
: Rows Affected
= 3
490 echo DELETE FROM T10 WHERE f1
= 1;
491 Statement Executed
: Rows Affected
= 3
492 echo SELECT
* FROM T1
;
493 ---------------------------------------------------------
494 T1.f1 T1.f2 T1.f3 T1.f4 T1.f5
495 ---------------------------------------------------------
496 2 20 201 20.020000 Jagannath
497 2 21 201 20.020000 Jagannath
498 2 21 211 20.020000 Jagannath
500 echo SELECT
* FROM T2
;
501 ---------------------------------------------------------
502 T2.f1 T2.f2 T2.f3 T2.f4 T2.f5
503 ---------------------------------------------------------
504 2 20 201 20.020000 Jagannath
505 2 21 201 20.020000 Jagannath
506 2 21 211 20.020000 Jagannath
508 echo SELECT
* FROM T3
;
509 ---------------------------------------------------------
510 T3.f1 T3.f2 T3.f3 T3.f4 T3.f5
511 ---------------------------------------------------------
512 2 20 201 20.020000 Jagannath
513 2 21 201 20.020000 Jagannath
514 2 21 211 20.020000 Jagannath
516 echo SELECT
* FROM T4
;
517 ---------------------------------------------------------
518 T4.f1 T4.f2 T4.f3 T4.f4 T4.f5
519 ---------------------------------------------------------
520 2 20 201 20.020000 Jagannath
521 2 21 201 20.020000 Jagannath
522 2 21 211 20.020000 Jagannath
524 echo SELECT
* FROM T5
;
525 ---------------------------------------------------------
526 T5.f1 T5.f2 T5.f3 T5.f4 T5.f5
527 ---------------------------------------------------------
528 2 20 201 20.020000 Jagannath
529 2 21 201 20.020000 Jagannath
530 2 21 211 20.020000 Jagannath
532 echo SELECT
* FROM T6
;
533 ---------------------------------------------------------
534 T6.f1 T6.f2 T6.f3 T6.f4 T6.f5
535 ---------------------------------------------------------
536 2 20 201 20.020000 Jagannath
537 2 21 201 20.020000 Jagannath
538 2 21 211 20.020000 Jagannath
540 echo SELECT
* FROM T7
;
541 ---------------------------------------------------------
542 T7.f1 T7.f2 T7.f3 T7.f4 T7.f5
543 ---------------------------------------------------------
544 2 20 201 20.020000 Jagannath
545 2 21 201 20.020000 Jagannath
546 2 21 211 20.020000 Jagannath
548 echo SELECT
* FROM T8
;
549 ---------------------------------------------------------
550 T8.f1 T8.f2 T8.f3 T8.f4 T8.f5
551 ---------------------------------------------------------
552 2 20 201 20.020000 Jagannath
553 2 21 201 20.020000 Jagannath
554 2 21 211 20.020000 Jagannath
556 echo SELECT
* FROM T9
;
557 ---------------------------------------------------------
558 T9.f1 T9.f2 T9.f3 T9.f4 T9.f5
559 ---------------------------------------------------------
560 2 20 201 20.020000 Jagannath
561 2 21 201 20.020000 Jagannath
562 2 21 211 20.020000 Jagannath
564 echo SELECT
* FROM T10
;
565 ---------------------------------------------------------
566 T10.f1 T10.f2 T10.f3 T10.f4 T10.f5
567 ---------------------------------------------------------
568 2 20 201 20.020000 Jagannath
569 2 21 201 20.020000 Jagannath
570 2 21 211 20.020000 Jagannath