inputtest005.sql

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

create table t1(f1 int, f2 char(30), primary key (f1));
insert into t1 values(123, 'india');
insert into t1 values(72, 'Laxwoman72');
insert into t1 values(25, 'Laxwoman25');
insert into t1 values(77, 'Laxwoman77');
insert into t1 values(78, 'Laxwoman78');
insert into t1 values(79, 'Laxwoman79');
insert into t1 values(80, 'Laxwoman80');
insert into t1 values(26, 'Laxwoman26');
insert into t1 values(27, 'Laxwoman27');
insert into t1 values(28, 'Laxwoman28');
insert into t1 values(29, 'Laxwoman29');
insert into t1 values(48, 'London');
insert into t1 values(49, 'Laxwoman49');
insert into t1 values(50, 'Laxwoman50');
insert into t1 values(51, 'Laxwoman51');
insert into t1 values(142, 'Laxwoman52');
insert into t1 values(53, 'Laxwoman53');
insert into t1 values(54, 'Laxwoman54');
insert into t1 values(55, 'Laxwoman55');
insert into t1 values(56, 'Laxwoman56');
insert into t1 values(90, 'Laxwoman90');
insert into t1 values(91, 'Laxwoman91');
insert into t1 values(92, 'Laxwoman92');
insert into t1 values(93, 'Laxwoman93');
insert into t1 values(94, 'Laxwoman94');
insert into t1 values(95, 'Laxwoman95');
insert into t1 values(73, 'Laxwoman73');
insert into t1 values(74, 'Laxwoman74');
insert into t1 values(456, 'Laxwoman75');
insert into t1 values(76, 'Laxwoman76');
insert into t1 values(81, 'Laxwoman81');
insert into t1 values(82, 'Laxwoman82');
insert into t1 values(40, 'Laxwoman40');
insert into t1 values(41, 'Laxwoman41');
insert into t1 values(42, 'Laxwoman42');
insert into t1 values(43, 'Laxwoman43');
insert into t1 values(44, 'Laxwoman44');
insert into t1 values(45, 'Laxwoman45');
insert into t1 values(46, 'Laxwoman46');
insert into t1 values(47, 'Laxwoman47');
insert into t1 values(18, 'Laxwoman18');
insert into t1 values(555, 'Malaysia63');
insert into t1 values(64, 'Laxwoman64');
insert into t1 values(65, 'Laxwoman65');
insert into t1 values(66, 'Laxwoman66');
insert into t1 values(67, 'Laxwoman67');
insert into t1 values(68, 'Laxwoman68');
insert into t1 values(19, 'Laxwoman19');
insert into t1 values(823, 'Laxwoman83');
insert into t1 values(84, 'Laxwoman84');
insert into t1 values(85, 'Laxwoman85');
insert into t1 values(11, 'Laxwoman11');
insert into t1 values(12, 'Laxwoman12');
insert into t1 values(13, 'Laxwoman13');
insert into t1 values(14, 'Laxwoman14');
insert into t1 values(15, 'Laxwoman15');
insert into t1 values(16, 'Laxwoman16');
insert into t1 values(17, 'Laxwoman17');
insert into t1 values(530, 'Laxwoman30');
insert into t1 values(31, 'Laxwoman31');
insert into t1 values(32, 'Laxwoman32');
insert into t1 values(33, 'Paris3');
insert into t1 values(34, 'Laxwoman34');
insert into t1 values(35, 'Laxwoman35');
insert into t1 values(36, 'Pakistan');
insert into t1 values(37, 'Laxwoman37');
insert into t1 values(777, 'Laxwoman38');
insert into t1 values(39, 'Laxwoman39');
insert into t1 values(20, 'Laxwoman20');
insert into t1 values(21, 'Laxwoman21');
insert into t1 values(22, 'Laxwoman22');
insert into t1 values(23, 'Laxwoman23');
insert into t1 values(24, 'Laxwoman24');
insert into t1 values(96, 'Laxwoman96');
insert into t1 values(97, 'Laxwoman97');
insert into t1 values(98, 'Laxwoman98');
insert into t1 values(1, 'Laxwoman1');
insert into t1 values(2, 'Laxwoman2');
insert into t1 values(3, 'Laxwoman3');
insert into t1 values(4, 'Laxwoman4');
insert into t1 values(5, 'Laxwoman5');
insert into t1 values(6, 'Laxwoman6');
insert into t1 values(7, 'Laxwoman7');
insert into t1 values(8, 'Laxwoman8');
insert into t1 values(9, 'Laxwoman9');
insert into t1 values(10, 'Laxwoman10');
insert into t1 values(57, 'Laxwoman57');
insert into t1 values(58, 'Laxwoman58');
insert into t1 values(59, 'Laxwoman59');
insert into t1 values(60, 'Laxwoman60');
insert into t1 values(61, 'Laxwoman61');
insert into t1 values(62, 'Laxwoman62');
insert into t1 values(69, 'Laxwoman69');
insert into t1 values(70, 'Laxwoman70');
insert into t1 values(86, 'Laxwoman86');
insert into t1 values(87, 'Laxwoman87');
insert into t1 values(88, 'Laxwoman88');
insert into t1 values(89, 'Laxwoman89');
insert into t1 values(1189, 'Laxwoman89');
insert into t1 values(2289, 'Laxwoman89');
insert into t1 values(3389, 'Laxwoman89');