create.sql

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

insert into t67 values(8,81);
insert into t67 values(9,91);
insert into t67 values(10,101);
create table t68 (f1 int primary key, f2 int);
insert into t68 values(1,11);
insert into t68 values(2,21);
insert into t68 values(3,31);
insert into t68 values(4,41);
insert into t68 values(5,51);
insert into t68 values(6,61);
insert into t68 values(7,71);
insert into t68 values(8,81);
insert into t68 values(9,91);
insert into t68 values(10,101);
create table t69 (f1 int primary key, f2 int);
insert into t69 values(1,11);
insert into t69 values(2,21);
insert into t69 values(3,31);
insert into t69 values(4,41);
insert into t69 values(5,51);
insert into t69 values(6,61);
insert into t69 values(7,71);
insert into t69 values(8,81);
insert into t69 values(9,91);
insert into t69 values(10,101);
create table t70 (f1 int primary key, f2 int);
insert into t70 values(1,11);
insert into t70 values(2,21);
insert into t70 values(3,31);
insert into t70 values(4,41);
insert into t70 values(5,51);
insert into t70 values(6,61);
insert into t70 values(7,71);
insert into t70 values(8,81);
insert into t70 values(9,91);
insert into t70 values(10,101);
create table t71 (f1 int primary key, f2 int);
insert into t71 values(1,11);
insert into t71 values(2,21);
insert into t71 values(3,31);
insert into t71 values(4,41);
insert into t71 values(5,51);
insert into t71 values(6,61);
insert into t71 values(7,71);
insert into t71 values(8,81);
insert into t71 values(9,91);
insert into t71 values(10,101);
create table t72 (f1 int primary key, f2 int);
insert into t72 values(1,11);
insert into t72 values(2,21);
insert into t72 values(3,31);
insert into t72 values(4,41);
insert into t72 values(5,51);
insert into t72 values(6,61);
insert into t72 values(7,71);
insert into t72 values(8,81);
insert into t72 values(9,91);
insert into t72 values(10,101);
create table t73 (f1 int primary key, f2 int);
insert into t73 values(1,11);
insert into t73 values(2,21);
insert into t73 values(3,31);
insert into t73 values(4,41);
insert into t73 values(5,51);
insert into t73 values(6,61);
insert into t73 values(7,71);
insert into t73 values(8,81);
insert into t73 values(9,91);
insert into t73 values(10,101);
create table t74 (f1 int primary key, f2 int);
insert into t74 values(1,11);
insert into t74 values(2,21);
insert into t74 values(3,31);
insert into t74 values(4,41);
insert into t74 values(5,51);
insert into t74 values(6,61);
insert into t74 values(7,71);
insert into t74 values(8,81);
insert into t74 values(9,91);
insert into t74 values(10,101);
create table t75 (f1 int primary key, f2 int);
insert into t75 values(1,11);
insert into t75 values(2,21);
insert into t75 values(3,31);
insert into t75 values(4,41);
insert into t75 values(5,51);
insert into t75 values(6,61);
insert into t75 values(7,71);
insert into t75 values(8,81);
insert into t75 values(9,91);
insert into t75 values(10,101);
create table t76 (f1 int primary key, f2 int);
insert into t76 values(1,11);
insert into t76 values(2,21);
insert into t76 values(3,31);
insert into t76 values(4,41);
insert into t76 values(5,51);
insert into t76 values(6,61);
insert into t76 values(7,71);
insert into t76 values(8,81);
insert into t76 values(9,91);
insert into t76 values(10,101);
create table t77 (f1 int primary key, f2 int);
insert into t77 values(1,11);
insert into t77 values(2,21);
insert into t77 values(3,31);
insert into t77 values(4,41);
insert into t77 values(5,51);
insert into t77 values(6,61);
insert into t77 values(7,71);
insert into t77 values(8,81);
insert into t77 values(9,91);
insert into t77 values(10,101);
create table t78 (f1 int primary key, f2 int);
insert into t78 values(1,11);
insert into t78 values(2,21);
insert into t78 values(3,31);
insert into t78 values(4,41);
insert into t78 values(5,51);
insert into t78 values(6,61);
insert into t78 values(7,71);
insert into t78 values(8,81);
insert into t78 values(9,91);
insert into t78 values(10,101);
create table t79 (f1 int primary key, f2 int);
insert into t79 values(1,11);
insert into t79 values(2,21);
insert into t79 values(3,31);
insert into t79 values(4,41);
insert into t79 values(5,51);
insert into t79 values(6,61);
insert into t79 values(7,71);
insert into t79 values(8,81);
insert into t79 values(9,91);
insert into t79 values(10,101);
create table t80 (f1 int primary key, f2 int);
insert into t80 values(1,11);
insert into t80 values(2,21);
insert into t80 values(3,31);
insert into t80 values(4,41);
insert into t80 values(5,51);
insert into t80 values(6,61);
insert into t80 values(7,71);
insert into t80 values(8,81);
insert into t80 values(9,91);
insert into t80 values(10,101);
create table t81 (f1 int primary key, f2 int);
insert into t81 values(1,11);
insert into t81 values(2,21);
insert into t81 values(3,31);
insert into t81 values(4,41);
insert into t81 values(5,51);
insert into t81 values(6,61);
insert into t81 values(7,71);
insert into t81 values(8,81);
insert into t81 values(9,91);
insert into t81 values(10,101);
create table t82 (f1 int primary key, f2 int);
insert into t82 values(1,11);
insert into t82 values(2,21);
insert into t82 values(3,31);
insert into t82 values(4,41);
insert into t82 values(5,51);
insert into t82 values(6,61);
insert into t82 values(7,71);
insert into t82 values(8,81);
insert into t82 values(9,91);
insert into t82 values(10,101);
create table t83 (f1 int primary key, f2 int);
insert into t83 values(1,11);
insert into t83 values(2,21);
insert into t83 values(3,31);
insert into t83 values(4,41);
insert into t83 values(5,51);
insert into t83 values(6,61);
insert into t83 values(7,71);
insert into t83 values(8,81);
insert into t83 values(9,91);
insert into t83 values(10,101);
create table t84 (f1 int primary key, f2 int);
insert into t84 values(1,11);
insert into t84 values(2,21);
insert into t84 values(3,31);
insert into t84 values(4,41);
insert into t84 values(5,51);
insert into t84 values(6,61);
insert into t84 values(7,71);
insert into t84 values(8,81);
insert into t84 values(9,91);
insert into t84 values(10,101);
create table t85 (f1 int primary key, f2 int);
insert into t85 values(1,11);
insert into t85 values(2,21);
insert into t85 values(3,31);
insert into t85 values(4,41);
insert into t85 values(5,51);
insert into t85 values(6,61);
insert into t85 values(7,71);
insert into t85 values(8,81);
insert into t85 values(9,91);
insert into t85 values(10,101);
create table t86 (f1 int primary key, f2 int);
insert into t86 values(1,11);
insert into t86 values(2,21);
insert into t86 values(3,31);
insert into t86 values(4,41);
insert into t86 values(5,51);
insert into t86 values(6,61);
insert into t86 values(7,71);
insert into t86 values(8,81);
insert into t86 values(9,91);
insert into t86 values(10,101);
create table t87 (f1 int primary key, f2 int);
insert into t87 values(1,11);
insert into t87 values(2,21);
insert into t87 values(3,31);
insert into t87 values(4,41);
insert into t87 values(5,51);
insert into t87 values(6,61);
insert into t87 values(7,71);
insert into t87 values(8,81);
insert into t87 values(9,91);
insert into t87 values(10,101);
create table t88 (f1 int primary key, f2 int);
insert into t88 values(1,11);
insert into t88 values(2,21);
insert into t88 values(3,31);
insert into t88 values(4,41);
insert into t88 values(5,51);
insert into t88 values(6,61);
insert into t88 values(7,71);
insert into t88 values(8,81);
insert into t88 values(9,91);
insert into t88 values(10,101);
create table t89 (f1 int primary key, f2 int);
insert into t89 values(1,11);
insert into t89 values(2,21);
insert into t89 values(3,31);
insert into t89 values(4,41);
insert into t89 values(5,51);
insert into t89 values(6,61);
insert into t89 values(7,71);
insert into t89 values(8,81);
insert into t89 values(9,91);
insert into t89 values(10,101);
create table t90 (f1 int primary key, f2 int);
insert into t90 values(1,11);
insert into t90 values(2,21);
insert into t90 values(3,31);
insert into t90 values(4,41);
insert into t90 values(5,51);
insert into t90 values(6,61);
insert into t90 values(7,71);
insert into t90 values(8,81);
insert into t90 values(9,91);
insert into t90 values(10,101);
create table t91 (f1 int primary key, f2 int);
insert into t91 values(1,11);
insert into t91 values(2,21);
insert into t91 values(3,31);
insert into t91 values(4,41);
insert into t91 values(5,51);
insert into t91 values(6,61);
insert into t91 values(7,71);
insert into t91 values(8,81);
insert into t91 values(9,91);
insert into t91 values(10,101);
create table t92 (f1 int primary key, f2 int);
insert into t92 values(1,11);
insert into t92 values(2,21);
insert into t92 values(3,31);
insert into t92 values(4,41);
insert into t92 values(5,51);
insert into t92 values(6,61);
insert into t92 values(7,71);
insert into t92 values(8,81);
insert into t92 values(9,91);
insert into t92 values(10,101);
create table t93 (f1 int primary key, f2 int);
insert into t93 values(1,11);
insert into t93 values(2,21);
insert into t93 values(3,31);
insert into t93 values(4,41);
insert into t93 values(5,51);
insert into t93 values(6,61);
insert into t93 values(7,71);
insert into t93 values(8,81);
insert into t93 values(9,91);
insert into t93 values(10,101);
create table t94 (f1 int primary key, f2 int);
insert into t94 values(1,11);
insert into t94 values(2,21);
insert into t94 values(3,31);
insert into t94 values(4,41);
insert into t94 values(5,51);
insert into t94 values(6,61);
insert into t94 values(7,71);
insert into t94 values(8,81);
insert into t94 values(9,91);
insert into t94 values(10,101);
create table t95 (f1 int primary key, f2 int);
insert into t95 values(1,11);
insert into t95 values(2,21);
insert into t95 values(3,31);
insert into t95 values(4,41);
insert into t95 values(5,51);
insert into t95 values(6,61);
insert into t95 values(7,71);
insert into t95 values(8,81);
insert into t95 values(9,91);
insert into t95 values(10,101);
create table t96 (f1 int primary key, f2 int);
insert into t96 values(1,11);
insert into t96 values(2,21);
insert into t96 values(3,31);
insert into t96 values(4,41);
insert into t96 values(5,51);
insert into t96 values(6,61);
insert into t96 values(7,71);
insert into t96 values(8,81);
insert into t96 values(9,91);
insert into t96 values(10,101);
create table t97 (f1 int primary key, f2 int);
insert into t97 values(1,11);
insert into t97 values(2,21);
insert into t97 values(3,31);
insert into t97 values(4,41);
insert into t97 values(5,51);
insert into t97 values(6,61);
insert into t97 values(7,71);
insert into t97 values(8,81);
insert into t97 values(9,91);
insert into t97 values(10,101);
create table t98 (f1 int primary key, f2 int);
insert into t98 values(1,11);
insert into t98 values(2,21);
insert into t98 values(3,31);
insert into t98 values(4,41);
insert into t98 values(5,51);
insert into t98 values(6,61);
insert into t98 values(7,71);
insert into t98 values(8,81);
insert into t98 values(9,91);
insert into t98 values(10,101);
create table t99 (f1 int primary key, f2 int);
insert into t99 values(1,11);
insert into t99 values(2,21);
insert into t99 values(3,31);
insert into t99 values(4,41);
insert into t99 values(5,51);
insert into t99 values(6,61);
insert into t99 values(7,71);
insert into t99 values(8,81);
insert into t99 values(9,91);
insert into t99 values(10,101);
create table t100 (f1 int primary key, f2 int);
insert into t100 values(1,11);
insert into t100 values(2,21);
insert into t100 values(3,31);
insert into t100 values(4,41);
insert into t100 values(5,51);
insert into t100 values(6,61);
insert into t100 values(7,71);
insert into t100 values(8,81);
insert into t100 values(9,91);
insert into t100 values(10,101);