1 echo create table t1 (f1 int, f2 char(10), f3 bigint);
2 create table t1 (f1 int, f2 char(10), f3 bigint);
4 echo insert into t1 values(10,'india',1234321);
5 insert into t1 values(10,'india',1234321);
6 echo insert into t1 (f1, f2 ) values(20,'INDIA');
7 insert into t1 (f1, f2 ) values(20,'INDIA');
8 echo insert into t1 (f2, f3 ) values('orissa',123432);
9 insert into t1 (f2, f3 ) values('orissa',123432);
10 echo insert into t1 (f1, f3 ) values(30,123432);
11 insert into t1 (f1, f3 ) values(30,123432);
13 echo select * from t1;
15 echo select f1,f2,f3 from t1;
16 select f1,f2,f3 from t1;
17 echo select f2,f1,f3 from t1;
18 select f2,f1,f3 from t1;
19 echo select f1,f1,f1,f1,f1 from t1;
20 select f1,f1,f1,f1,f1 from t1;
21 echo select f2,f2,f2,f2,f2 from t1;
22 select f2,f2,f2,f2,f2 from t1;
23 echo select f3,f3,f3,f3,f3 from t1;
24 select f3,f3,f3,f3,f3 from t1;
25 echo select f1,f1,f2,f2,f3,f3 from t1;
26 select f1,f1,f2,f2,f3,f3 from t1;
27 echo select f1,f2,f1,f3,f3,f2,f1,f3 from t1;
28 select f1,f2,f1,f3,f3,f2,f1,f3 from t1;