inputtest003.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, 'Lakshya72');
insert into t1 values(73, 'Lakshya73');
insert into t1 values(74, 'Lakshya74');
insert into t1 values(456, 'Lakshya75');
insert into t1 values(76, 'Lakshya76');
insert into t1 values(77, 'Lakshya77');
insert into t1 values(78, 'Lakshya78');
insert into t1 values(79, 'Lakshya79');
insert into t1 values(80, 'Lakshya80');
insert into t1 values(81, 'Lakshya81');
insert into t1 values(82, 'Lakshya82');
insert into t1 values(40, 'Lakshya40');
insert into t1 values(41, 'Lakshya41');
insert into t1 values(42, 'Lakshya42');
insert into t1 values(43, 'Lakshya43');
insert into t1 values(44, 'Lakshya44');
insert into t1 values(45, 'Lakshya45');
insert into t1 values(46, 'Lakshya46');
insert into t1 values(47, 'Lakshya47');
insert into t1 values(18, 'Lakshya18');
insert into t1 values(555, 'Malaysia63');
insert into t1 values(64, 'Lakshya64');
insert into t1 values(65, 'Lakshya65');
insert into t1 values(66, 'Lakshya66');
insert into t1 values(67, 'Lakshya67');
insert into t1 values(68, 'Lakshya68');
insert into t1 values(19, 'Lakshya19');
insert into t1 values(823, 'Lakshya83');
insert into t1 values(84, 'Lakshya84');
insert into t1 values(85, 'Lakshya85');
insert into t1 values(11, 'Lakshya11');
insert into t1 values(12, 'Lakshya12');
insert into t1 values(13, 'Lakshya13');
insert into t1 values(14, 'Lakshya14');
insert into t1 values(15, 'Lakshya15');
insert into t1 values(16, 'Lakshya16');
insert into t1 values(17, 'Lakshya17');
insert into t1 values(530, 'Lakshya30');
insert into t1 values(31, 'Lakshya31');
insert into t1 values(32, 'Lakshya32');
insert into t1 values(33, 'Lakshya33');
insert into t1 values(34, 'Lakshya34');
insert into t1 values(35, 'Lakshya35');
insert into t1 values(36, 'Pakistan');
insert into t1 values(37, 'Lakshya37');
insert into t1 values(777, 'Lakshya38');
insert into t1 values(39, 'Lakshya39');
insert into t1 values(20, 'Lakshya20');
insert into t1 values(21, 'Lakshya21');
insert into t1 values(22, 'Lakshya22');
insert into t1 values(23, 'Lakshya23');
insert into t1 values(24, 'Lakshya24');
insert into t1 values(25, 'Lakshya25');
insert into t1 values(26, 'Lakshya26');
insert into t1 values(27, 'Lakshya27');
insert into t1 values(28, 'Lakshya28');
insert into t1 values(29, 'Lakshya29');
insert into t1 values(48, 'Lakshya48');
insert into t1 values(49, 'Lakshya49');
insert into t1 values(50, 'Lakshya50');
insert into t1 values(51, 'Lakshya51');
insert into t1 values(142, 'Lakshya52');
insert into t1 values(53, 'Lakshya53');
insert into t1 values(54, 'Lakshya54');
insert into t1 values(55, 'Lakshya55');
insert into t1 values(56, 'Lakshya56');
insert into t1 values(90, 'Lakshya90');
insert into t1 values(91, 'Lakshya91');
insert into t1 values(92, 'Lakshya92');
insert into t1 values(93, 'Lakshya93');
insert into t1 values(94, 'Lakshya94');
insert into t1 values(95, 'Lakshya95');
insert into t1 values(96, 'Lakshya96');
insert into t1 values(97, 'Lakshya97');
insert into t1 values(98, 'Lakshya98');
insert into t1 values(99, 'Lakshya99');
insert into t1 values(100, 'Lakshya100');
insert into t1 values(1, 'Lakshya1');
insert into t1 values(2, 'Lakshya2');
insert into t1 values(3, 'Lakshya3');
insert into t1 values(4, 'Lakshya4');
insert into t1 values(5, 'Lakshya5');
insert into t1 values(6, 'Lakshya6');
insert into t1 values(7, 'Lakshya7');
insert into t1 values(8, 'Lakshya8');
insert into t1 values(9, 'Lakshya9');
insert into t1 values(10, 'Lakshya10');
insert into t1 values(57, 'Lakshya57');
insert into t1 values(58, 'Lakshya58');
insert into t1 values(59, 'Lakshya59');
insert into t1 values(60, 'Lakshya60');
insert into t1 values(61, 'Lakshya61');
insert into t1 values(62, 'Lakshya62');
insert into t1 values(69, 'Lakshya69');
insert into t1 values(70, 'Lakshya70');
insert into t1 values(86, 'Lakshya86');
insert into t1 values(87, 'Lakshya87');
insert into t1 values(88, 'Lakshya88');
insert into t1 values(89, 'Lakshya89');