inputtest012.sql

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

create table t1 (f1 int, f2 int, primary key(f1));
insert into t1 values (0, 01);
insert into t1 values (1, 11);
insert into t1 values (2, 21);
insert into t1 values (3, 31);
insert into t1 values (4, 41);
insert into t1 values (5, 51);
insert into t1 values (6, 61);
insert into t1 values (7, 71);
insert into t1 values (8, 81);
insert into t1 values (9, 91);
insert into t1 values (10, 101);
insert into t1 values (11, 111);
insert into t1 values (12, 121);
insert into t1 values (13, 131);
insert into t1 values (14, 141);
insert into t1 values (15, 151);
insert into t1 values (16, 161);
insert into t1 values (17, 171);
insert into t1 values (18, 181);
insert into t1 values (19, 191);
insert into t1 values (20, 201);
insert into t1 values (21, 211);
insert into t1 values (22, 221);
insert into t1 values (23, 231);
insert into t1 values (24, 241);
insert into t1 values (25, 251);
insert into t1 values (26, 261);
insert into t1 values (27, 271);
insert into t1 values (28, 281);
insert into t1 values (29, 291);
insert into t1 values (30, 301);
insert into t1 values (31, 311);
insert into t1 values (32, 321);
insert into t1 values (33, 331);
insert into t1 values (34, 341);
insert into t1 values (35, 351);
insert into t1 values (36, 361);
insert into t1 values (37, 371);
insert into t1 values (38, 381);
insert into t1 values (39, 391);
insert into t1 values (40, 401);
insert into t1 values (41, 411);
insert into t1 values (42, 421);
insert into t1 values (43, 431);
insert into t1 values (44, 441);
insert into t1 values (45, 451);
insert into t1 values (46, 461);
insert into t1 values (47, 471);
insert into t1 values (48, 481);
insert into t1 values (49, 491);
insert into t1 values (50, 501);
insert into t1 values (51, 511);
insert into t1 values (52, 521);
insert into t1 values (53, 531);
insert into t1 values (54, 541);
insert into t1 values (55, 551);
insert into t1 values (56, 561);
insert into t1 values (57, 571);
insert into t1 values (58, 581);
insert into t1 values (59, 591);
insert into t1 values (60, 601);
insert into t1 values (61, 611);
insert into t1 values (62, 621);
insert into t1 values (63, 631);
insert into t1 values (64, 641);
insert into t1 values (65, 651);
insert into t1 values (66, 661);
insert into t1 values (67, 671);
insert into t1 values (68, 681);
insert into t1 values (69, 691);
insert into t1 values (70, 701);
insert into t1 values (71, 711);
insert into t1 values (72, 721);
insert into t1 values (73, 731);
insert into t1 values (74, 741);
insert into t1 values (75, 751);
insert into t1 values (76, 761);
insert into t1 values (77, 771);
insert into t1 values (78, 781);
insert into t1 values (79, 791);
insert into t1 values (80, 801);
insert into t1 values (81, 811);
insert into t1 values (82, 821);
insert into t1 values (83, 831);
insert into t1 values (84, 841);
insert into t1 values (85, 851);
insert into t1 values (86, 861);
insert into t1 values (87, 871);
insert into t1 values (88, 881);
insert into t1 values (89, 891);
insert into t1 values (90, 901);
insert into t1 values (91, 911);
insert into t1 values (92, 921);
insert into t1 values (93, 931);
insert into t1 values (94, 941);
insert into t1 values (95, 951);
insert into t1 values (96, 961);
insert into t1 values (97, 971);
insert into t1 values (98, 981);
insert into t1 values (99, 991);
insert into t1 values (100, 1001);
insert into t1 values (101, 1011);
insert into t1 values (102, 1021);
insert into t1 values (103, 1031);
insert into t1 values (104, 1041);
insert into t1 values (105, 1051);
insert into t1 values (106, 1061);
insert into t1 values (107, 1071);
insert into t1 values (108, 1081);
insert into t1 values (109, 1091);
insert into t1 values (110, 1101);
insert into t1 values (111, 1111);
insert into t1 values (112, 1121);
insert into t1 values (113, 1131);
insert into t1 values (114, 1141);
insert into t1 values (115, 1151);
insert into t1 values (116, 1161);
insert into t1 values (117, 1171);
insert into t1 values (118, 1181);
insert into t1 values (119, 1191);
insert into t1 values (120, 1201);
insert into t1 values (121, 1211);
insert into t1 values (122, 1221);
insert into t1 values (123, 1231);
insert into t1 values (124, 1241);
insert into t1 values (125, 1251);
insert into t1 values (126, 1261);
insert into t1 values (127, 1271);
insert into t1 values (128, 1281);
insert into t1 values (129, 1291);
insert into t1 values (130, 1301);
insert into t1 values (131, 1311);
insert into t1 values (132, 1321);
insert into t1 values (133, 1331);
insert into t1 values (134, 1341);
insert into t1 values (135, 1351);
insert into t1 values (136, 1361);
insert into t1 values (137, 1371);
insert into t1 values (138, 1381);
insert into t1 values (139, 1391);
insert into t1 values (140, 1401);
insert into t1 values (141, 1411);
insert into t1 values (142, 1421);
insert into t1 values (143, 1431);
insert into t1 values (144, 1441);
insert into t1 values (145, 1451);
insert into t1 values (146, 1461);
insert into t1 values (147, 1471);
insert into t1 values (148, 1481);
insert into t1 values (149, 1491);
insert into t1 values (150, 1501);
insert into t1 values (151, 1511);
insert into t1 values (152, 1521);
insert into t1 values (153, 1531);
insert into t1 values (154, 1541);
insert into t1 values (155, 1551);
insert into t1 values (156, 1561);