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;
16 echo update t1 set f1=10;
18 echo select * from t1;
20 echo update t1 set f2='hello';
21 update t1 set f2='hello';
22 echo select * from t1;
24 echo update t1 set f3=10000;
25 update t1 set f3=10000;
27 echo select * from t1;
30 echo create table t2 (f1 tinyint, f2 float);
31 create table t2 (f1 tinyint, f2 float);
33 echo insert into t2 values (112, 235.50);
34 insert into t2 values (112, 235.50);
35 echo insert into t2 (f1) values (220);
36 insert into t2 (f1) values (220);
37 echo insert into t2 (f2) values (100.50);
38 insert into t2 (f2) values (100.50);
41 echo select * from t2;
43 echo update t2 set f2=250.50;
44 update t2 set f2=250.50;
45 echo update t2 set f1=125;
48 echo select * from t2;