inputtest006.sql

b树实现源码,linux和unix下运行,速度快,极好用

create table t1(f1 int not null, f2 int default '10');
create index indx1 on t1(f1);
create index indx2 on t1(f2);
insert into t1(f1) values(131);
insert into t1(f1) values(141);
insert into t1 values(13, 41);
insert into t1 values(143, 41);
insert into t1 values(153, 41);
insert into t1 values(163, 41);
insert into t1(f1) values(151);
insert into t1(f1) values(1631);
insert into t1 values(163, 41);
insert into t1 values(13, 41);
insert into t1 values(23, 41);
insert into t1(f1) values(551);
insert into t1(f1) values(631);
insert into t1 values(43, 41);
insert into t1 values(3, 41);
insert into t1 values(3, 41);
insert into t1 values(33, 41);
insert into t1(f1) values(31);
insert into t1(f1) values(31);
insert into t1 values(4, 41);
insert into t1(f1) values(31);
insert into t1(f1) values(31);
insert into t1(f1) values(31);
insert into t1(f1) values(31);
insert into t1(f1) values(31);
insert into t1(f1) values(41);
insert into t1 values(3, 41);
insert into t1 values(43, 41);
insert into t1 values(53, 41);
insert into t1 values(63, 41);
insert into t1(f1) values(51);
insert into t1(f1) values(631);
insert into t1 values(63, 41);
insert into t1 values(3, 41);
insert into t1 values(3, 41);
insert into t1(f1) values(51);
insert into t1(f1) values(631);
insert into t1 values(3, 41);
insert into t1 values(3, 41);
insert into t1 values(3, 41);
insert into t1 values(3, 41);
insert into t1(f1) values(31);
insert into t1(f1) values(31);
insert into t1 values(4, 41);
insert into t1(f1) values(41);
insert into t1 values(3, 41);
insert into t1 values(43, 41);
insert into t1 values(53, 41);
insert into t1 values(63, 41);
insert into t1(f1) values(51);
insert into t1(f1) values(631);
insert into t1 values(63, 41);
insert into t1 values(3, 41);
insert into t1 values(3, 41);
insert into t1(f1) values(51);
insert into t1(f1) values(631);
insert into t1 values(3, 41);
insert into t1 values(3, 41);
insert into t1 values(3, 41);
insert into t1 values(3, 41);
insert into t1(f1) values(31);
insert into t1(f1) values(31);
insert into t1 values(4, 41);
insert into t1(f1) values(41);
insert into t1 values(3, 41);
insert into t1 values(43, 41);
insert into t1 values(53, 41);
insert into t1 values(63, 41);
insert into t1(f1) values(51);
insert into t1(f1) values(631);
insert into t1 values(63, 41);
insert into t1 values(3, 41);
insert into t1 values(3, 41);
insert into t1(f1) values(51);
insert into t1(f1) values(631);
insert into t1 values(3, 41);
insert into t1 values(3, 41);
insert into t1 values(3, 41);
insert into t1 values(3, 41);
insert into t1(f1) values(31);
insert into t1(f1) values(31);
insert into t1 values(4, 41);
insert into t1 values(3, 41);
insert into t1 values(43, 41);
insert into t1 values(53, 41);
insert into t1 values(63, 41);
insert into t1(f1) values(51);
insert into t1(f1) values(631);
insert into t1 values(63, 41);
insert into t1 values(3, 41);
insert into t1 values(3, 41);
insert into t1(f1) values(51);
insert into t1(f1) values(6317);
insert into t1 values(3, 41);
insert into t1 values(3, 413);
insert into t1 values(3, 431);
insert into t1 values(3, 941);
insert into t1(f1) values(631);
insert into t1(f1) values(431);
insert into t1 values(14, 41);