test/sql/Order/alldatatype.sql

   1 create table t1(f0 tinyint, f1 smallint,f2 int,f3 bigint,f4 char(10),f5 float,f6 double,f7 date,f8 time,f9 timestamp);
   2 insert into t1 values(1, 10,100 ,1000,   'Bijay',1000,100000,'2009-03-01','11:59:59','2009-03-01 11:59:59');
   3 insert into t1 values(2, 11,110 ,1100, 'Jitendr',2000,200000,'2009-03-02','11:59:58','2009-03-02 11:59:59');
   4 insert into t1 values(3, 12,120 ,1000,   'Nihar',3000,300000,'2009-03-03','11:59:57','2009-03-03 11:59:59');
   5 insert into t1 values(4, 13,130 ,1100,  'Kishor',4000,400000,'2009-03-04','11:59:59','2009-03-04 11:59:59');
   6 insert into t1 values(5, 14,100 ,1000,   'Praba',5000,500000,'2009-03-01','11:59:58','2009-03-01 11:59:59');
   7 insert into t1 values(6, 15,110 ,1100,  'Sanjit',6000,600000,'2009-03-02','11:59:57','2009-03-02 11:59:59');
   8 insert into t1 values(7, 16,120 ,1000,  'Sanjay',7000,700000,'2009-03-03','11:59:59','2009-03-03 11:59:59');
   9 insert into t1 values(1, 17,130 ,1100, 'Arindam',8000,800000,'2009-03-04','11:59:58','2009-03-04 11:59:59');
  10 insert into t1 values(2, 10,100 ,1000,   'Bijay',9000,900000,'2009-03-01','11:59:57','2009-03-01 11:59:59');
  11 insert into t1 values(3, 11,110 ,1100, 'Jitendr',1000,100000,'2009-03-02','11:59:58','2009-03-02 11:59:59');
  12 insert into t1 values(4, 12,120 ,1000,   'Nihar',2000,200000,'2009-03-03','11:59:57','2009-03-03 11:59:59');
  13 insert into t1 values(5, 13,130 ,1100,  'Kishor',3000,300000,'2009-03-05','11:59:56','2009-03-05 11:59:59');
  14 insert into t1 values(6, 14,100 ,1000,   'Praba',4000,400000,'2009-03-01','11:59:55','2009-03-04 11:59:59');
  15 insert into t1 values(7, 15,110 ,1100,  'Sanjit',5000,500000,'2009-03-02','11:59:56','2009-03-01 11:59:59');
  16 insert into t1 values(1, 16,120 ,1000,  'Sanjay',6000,600000,'2009-03-03','11:59:55','2009-03-03 11:59:59');
  17 insert into t1 values(2, 17,130 ,1100, 'Arindam',7000,700000,'2009-03-01','11:59:59','2009-03-01 11:59:59');
  18 select * from t1;