adding test scripts
[csql.git] / test / jdbc / Statement / ins.sql
blobeb6a5d480f9cd9e6d6b2bf2b102fd11e11bd47f7
1 CREATE TABLE T1 (f1 int, f2 smallint, f3 tinyint, f4 bigint, f5 float, f6 char(10), f7 date, f8 time, f9 timestamp);
2 INSERT INTO T1 VALUES(100,10,1,1000,1000.00,'Nihar','2008-03-21','18:00:00','2008-03-21 18:00:00');
3 INSERT INTO T1 VALUES(200,20,1,1000,2000.00,'Nihar','2008-03-21','18:00:00','2008-03-21 18:00:00');
4 INSERT INTO T1 VALUES(300,30,1,1000,3000.00,'Nihar','2008-03-21','18:00:00','2008-03-21 18:00:00');
5 INSERT INTO T1 VALUES(100,40,1,1000,4000.00,'Nihar','2008-03-21','18:00:00','2008-03-21 18:00:00');
6 INSERT INTO T1 VALUES(200,50,1,1000,5000.00,'Nihar','2008-03-21','18:00:00','2008-03-21 18:00:00');
7 INSERT INTO T1 VALUES(400,60,1,1000,5000.00,'Nihar','2008-03-21','18:00:00','2008-03-21 18:00:00');
8 INSERT INTO T1 VALUES(100,70,1,1000,6000.00,'Nihar','2008-03-21','18:00:00','2008-03-21 18:00:00');
9 INSERT INTO T1 VALUES(200,80,1,1000,7000.00,'Nihar','2008-03-21','18:00:00','2008-03-21 18:00:00');
10 INSERT INTO T1 VALUES(300,90,1,1000,8000.00,'Nihar','2008-03-21','18:00:00','2008-03-21 18:00:00');
11 INSERT INTO T1 VALUES(1000,100,1,1000,9000.00,'Nihar','2008-03-21','18:00:00','2008-03-21 18:00:00');
12 echo Select f1,f5 from T1 order by f1;
13 Select f1,f5 from T1 order by f1;