1 echo create table t1
(f1 int
, f2 char
(10), f3 bigint
);
3 echo insert into t1 values
(10,'india',1234321);
4 Statement Executed
: Rows Affected
= 1
5 echo insert into t1
(f1
, f2
) values
(20,'INDIA');
6 Statement Executed
: Rows Affected
= 1
7 echo insert into t1
(f2
, f3
) values
('orissa',123432);
8 Statement Executed
: Rows Affected
= 1
9 echo insert into t1
(f1
, f3
) values
(30,123432);
10 Statement Executed
: Rows Affected
= 1
11 echo select * from t1
;
12 ---------------------------------------------------------
14 ---------------------------------------------------------
20 echo select f1
,f2
,f3 from t1
;
21 ---------------------------------------------------------
23 ---------------------------------------------------------
29 echo select f2
,f1
,f3 from t1
;
30 ---------------------------------------------------------
32 ---------------------------------------------------------
38 echo select f1
,f1
,f1
,f1
,f1 from t1
;
39 ---------------------------------------------------------
41 ---------------------------------------------------------
44 NULL NULL NULL NULL NULL
47 echo select f2
,f2
,f2
,f2
,f2 from t1
;
48 ---------------------------------------------------------
50 ---------------------------------------------------------
51 india india india india india
52 INDIA INDIA INDIA INDIA INDIA
53 orissa orissa orissa orissa orissa
54 NULL NULL NULL NULL NULL
56 echo select f3
,f3
,f3
,f3
,f3 from t1
;
57 ---------------------------------------------------------
59 ---------------------------------------------------------
60 1234321 1234321 1234321 1234321 1234321
61 NULL NULL NULL NULL NULL
62 123432 123432 123432 123432 123432
63 123432 123432 123432 123432 123432
65 echo select f1
,f1
,f2
,f2
,f3
,f3 from t1
;
66 ---------------------------------------------------------
68 ---------------------------------------------------------
69 10 10 india india
1234321 1234321
70 20 20 INDIA INDIA NULL NULL
71 NULL NULL orissa orissa
123432 123432
72 30 30 NULL NULL
123432 123432
74 echo select f1
,f2
,f1
,f3
,f3
,f2
,f1
,f3 from t1
;
75 ---------------------------------------------------------
76 f1 f2 f1 f3 f3 f2 f1 f3
77 ---------------------------------------------------------
78 10 india
10 1234321 1234321 india
10 1234321
79 20 INDIA
20 NULL NULL INDIA
20 NULL
80 NULL orissa NULL
123432 123432 orissa NULL
123432
81 30 NULL
30 123432 123432 NULL
30 123432