inputtest004.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, 'Laxman72');
insert into t1 values(73, 'Laxman73');
insert into t1 values(74, 'Laxman74');
insert into t1 values(456, 'Laxman75');
insert into t1 values(76, 'Laxman76');
insert into t1 values(77, 'Laxman77');
insert into t1 values(78, 'Laxman78');
insert into t1 values(79, 'Laxman79');
insert into t1 values(80, 'Laxman80');
insert into t1 values(81, 'Laxman81');
insert into t1 values(82, 'Laxman82');
insert into t1 values(40, 'Laxman40');
insert into t1 values(41, 'Laxman41');
insert into t1 values(42, 'Laxman42');
insert into t1 values(43, 'Laxman43');
insert into t1 values(44, 'Laxman44');
insert into t1 values(45, 'Laxman45');
insert into t1 values(46, 'Laxman46');
insert into t1 values(47, 'Laxman47');
insert into t1 values(18, 'Laxman18');
insert into t1 values(555, 'Malaysia63');
insert into t1 values(64, 'Laxman64');
insert into t1 values(65, 'Laxman65');
insert into t1 values(66, 'Laxman66');
insert into t1 values(67, 'Laxman67');
insert into t1 values(68, 'Laxman68');
insert into t1 values(19, 'Laxman19');
insert into t1 values(823, 'Laxman83');
insert into t1 values(84, 'Laxman84');
insert into t1 values(85, 'Laxman85');
insert into t1 values(11, 'Laxman11');
insert into t1 values(12, 'Laxman12');
insert into t1 values(13, 'Laxman13');
insert into t1 values(14, 'Laxman14');
insert into t1 values(15, 'Laxman15');
insert into t1 values(16, 'Laxman16');
insert into t1 values(17, 'Laxman17');
insert into t1 values(530, 'Laxman30');
insert into t1 values(31, 'Laxman31');
insert into t1 values(32, 'Laxman32');
insert into t1 values(33, 'Paris3');
insert into t1 values(34, 'Laxman34');
insert into t1 values(35, 'Laxman35');
insert into t1 values(36, 'Pakistan');
insert into t1 values(37, 'Laxman37');
insert into t1 values(777, 'Laxman38');
insert into t1 values(39, 'Laxman39');
insert into t1 values(20, 'Laxman20');
insert into t1 values(21, 'Laxman21');
insert into t1 values(22, 'Laxman22');
insert into t1 values(23, 'Laxman23');
insert into t1 values(24, 'Laxman24');
insert into t1 values(25, 'Laxman25');
insert into t1 values(26, 'Laxman26');
insert into t1 values(27, 'Laxman27');
insert into t1 values(28, 'Laxman28');
insert into t1 values(29, 'Laxman29');
insert into t1 values(48, 'London');
insert into t1 values(49, 'Laxman49');
insert into t1 values(50, 'Laxman50');
insert into t1 values(51, 'Laxman51');
insert into t1 values(142, 'Laxman52');
insert into t1 values(53, 'Laxman53');
insert into t1 values(54, 'Laxman54');
insert into t1 values(55, 'Laxman55');
insert into t1 values(56, 'Laxman56');
insert into t1 values(90, 'Laxman90');
insert into t1 values(91, 'Laxman91');
insert into t1 values(92, 'Laxman92');
insert into t1 values(93, 'Laxman93');
insert into t1 values(94, 'Laxman94');
insert into t1 values(95, 'Laxman95');
insert into t1 values(96, 'Laxman96');
insert into t1 values(97, 'Laxman97');
insert into t1 values(98, 'Laxman98');
insert into t1 values(99, 'Laxman99');
insert into t1 values(1, 'Laxman1');
insert into t1 values(2, 'Laxman2');
insert into t1 values(3, 'Laxman3');
insert into t1 values(4, 'Laxman4');
insert into t1 values(5, 'Laxman5');
insert into t1 values(6, 'Laxman6');
insert into t1 values(7, 'Laxman7');
insert into t1 values(8, 'Laxman8');
insert into t1 values(9, 'Laxman9');
insert into t1 values(10, 'Laxman10');
insert into t1 values(57, 'Laxman57');
insert into t1 values(58, 'Laxman58');
insert into t1 values(59, 'Laxman59');
insert into t1 values(60, 'Laxman60');
insert into t1 values(61, 'Laxman61');
insert into t1 values(62, 'Laxman62');
insert into t1 values(69, 'Laxman69');
insert into t1 values(70, 'Laxman70');
insert into t1 values(86, 'Laxman86');
insert into t1 values(87, 'Laxman87');
insert into t1 values(88, 'Laxman88');
insert into t1 values(89, 'Laxman89');