exp.test002.ksh

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

INSERT INTO t22 VALUES(3,31);
INSERT INTO t22 VALUES(4,41);
INSERT INTO t22 VALUES(5,51);
INSERT INTO t22 VALUES(6,61);
INSERT INTO t22 VALUES(7,71);
INSERT INTO t22 VALUES(8,81);
INSERT INTO t22 VALUES(9,91);
INSERT INTO t22 VALUES(10,101);
COMMIT;
INSERT INTO t23 VALUES(1,11);
INSERT INTO t23 VALUES(2,21);
INSERT INTO t23 VALUES(3,31);
INSERT INTO t23 VALUES(4,41);
INSERT INTO t23 VALUES(5,51);
INSERT INTO t23 VALUES(6,61);
INSERT INTO t23 VALUES(7,71);
INSERT INTO t23 VALUES(8,81);
INSERT INTO t23 VALUES(9,91);
INSERT INTO t23 VALUES(10,101);
COMMIT;
INSERT INTO t24 VALUES(1,11);
INSERT INTO t24 VALUES(2,21);
INSERT INTO t24 VALUES(3,31);
INSERT INTO t24 VALUES(4,41);
INSERT INTO t24 VALUES(5,51);
INSERT INTO t24 VALUES(6,61);
INSERT INTO t24 VALUES(7,71);
INSERT INTO t24 VALUES(8,81);
INSERT INTO t24 VALUES(9,91);
INSERT INTO t24 VALUES(10,101);
COMMIT;
INSERT INTO t25 VALUES(1,11);
INSERT INTO t25 VALUES(2,21);
INSERT INTO t25 VALUES(3,31);
INSERT INTO t25 VALUES(4,41);
INSERT INTO t25 VALUES(5,51);
INSERT INTO t25 VALUES(6,61);
INSERT INTO t25 VALUES(7,71);
INSERT INTO t25 VALUES(8,81);
INSERT INTO t25 VALUES(9,91);
INSERT INTO t25 VALUES(10,101);
COMMIT;
INSERT INTO t26 VALUES(1,11);
INSERT INTO t26 VALUES(2,21);
INSERT INTO t26 VALUES(3,31);
INSERT INTO t26 VALUES(4,41);
INSERT INTO t26 VALUES(5,51);
INSERT INTO t26 VALUES(6,61);
INSERT INTO t26 VALUES(7,71);
INSERT INTO t26 VALUES(8,81);
INSERT INTO t26 VALUES(9,91);
INSERT INTO t26 VALUES(10,101);
COMMIT;
INSERT INTO t27 VALUES(1,11);
INSERT INTO t27 VALUES(2,21);
INSERT INTO t27 VALUES(3,31);
INSERT INTO t27 VALUES(4,41);
INSERT INTO t27 VALUES(5,51);
INSERT INTO t27 VALUES(6,61);
INSERT INTO t27 VALUES(7,71);
INSERT INTO t27 VALUES(8,81);
INSERT INTO t27 VALUES(9,91);
INSERT INTO t27 VALUES(10,101);
COMMIT;
INSERT INTO t28 VALUES(1,11);
INSERT INTO t28 VALUES(2,21);
INSERT INTO t28 VALUES(3,31);
INSERT INTO t28 VALUES(4,41);
INSERT INTO t28 VALUES(5,51);
INSERT INTO t28 VALUES(6,61);
INSERT INTO t28 VALUES(7,71);
INSERT INTO t28 VALUES(8,81);
INSERT INTO t28 VALUES(9,91);
INSERT INTO t28 VALUES(10,101);
COMMIT;
INSERT INTO t29 VALUES(1,11);
INSERT INTO t29 VALUES(2,21);
INSERT INTO t29 VALUES(3,31);
INSERT INTO t29 VALUES(4,41);
INSERT INTO t29 VALUES(5,51);
INSERT INTO t29 VALUES(6,61);
INSERT INTO t29 VALUES(7,71);
INSERT INTO t29 VALUES(8,81);
INSERT INTO t29 VALUES(9,91);
INSERT INTO t29 VALUES(10,101);
COMMIT;
INSERT INTO t30 VALUES(1,11);
INSERT INTO t30 VALUES(2,21);
INSERT INTO t30 VALUES(3,31);
INSERT INTO t30 VALUES(4,41);
INSERT INTO t30 VALUES(5,51);
INSERT INTO t30 VALUES(6,61);
INSERT INTO t30 VALUES(7,71);
INSERT INTO t30 VALUES(8,81);
INSERT INTO t30 VALUES(9,91);
INSERT INTO t30 VALUES(10,101);
COMMIT;
INSERT INTO t31 VALUES(1,11);
INSERT INTO t31 VALUES(2,21);
INSERT INTO t31 VALUES(3,31);
INSERT INTO t31 VALUES(4,41);
INSERT INTO t31 VALUES(5,51);
INSERT INTO t31 VALUES(6,61);
INSERT INTO t31 VALUES(7,71);
INSERT INTO t31 VALUES(8,81);
INSERT INTO t31 VALUES(9,91);
INSERT INTO t31 VALUES(10,101);
COMMIT;
INSERT INTO t32 VALUES(1,11);
INSERT INTO t32 VALUES(2,21);
INSERT INTO t32 VALUES(3,31);
INSERT INTO t32 VALUES(4,41);
INSERT INTO t32 VALUES(5,51);
INSERT INTO t32 VALUES(6,61);
INSERT INTO t32 VALUES(7,71);
INSERT INTO t32 VALUES(8,81);
INSERT INTO t32 VALUES(9,91);
INSERT INTO t32 VALUES(10,101);
COMMIT;
INSERT INTO t33 VALUES(1,11);
INSERT INTO t33 VALUES(2,21);
INSERT INTO t33 VALUES(3,31);
INSERT INTO t33 VALUES(4,41);
INSERT INTO t33 VALUES(5,51);
INSERT INTO t33 VALUES(6,61);
INSERT INTO t33 VALUES(7,71);
INSERT INTO t33 VALUES(8,81);
INSERT INTO t33 VALUES(9,91);
INSERT INTO t33 VALUES(10,101);
COMMIT;
INSERT INTO t34 VALUES(1,11);
INSERT INTO t34 VALUES(2,21);
INSERT INTO t34 VALUES(3,31);
INSERT INTO t34 VALUES(4,41);
INSERT INTO t34 VALUES(5,51);
INSERT INTO t34 VALUES(6,61);
INSERT INTO t34 VALUES(7,71);
INSERT INTO t34 VALUES(8,81);
INSERT INTO t34 VALUES(9,91);
INSERT INTO t34 VALUES(10,101);
COMMIT;
INSERT INTO t35 VALUES(1,11);
INSERT INTO t35 VALUES(2,21);
INSERT INTO t35 VALUES(3,31);
INSERT INTO t35 VALUES(4,41);
INSERT INTO t35 VALUES(5,51);
INSERT INTO t35 VALUES(6,61);
INSERT INTO t35 VALUES(7,71);
INSERT INTO t35 VALUES(8,81);
INSERT INTO t35 VALUES(9,91);
INSERT INTO t35 VALUES(10,101);
COMMIT;
INSERT INTO t36 VALUES(1,11);
INSERT INTO t36 VALUES(2,21);
INSERT INTO t36 VALUES(3,31);
INSERT INTO t36 VALUES(4,41);
INSERT INTO t36 VALUES(5,51);
INSERT INTO t36 VALUES(6,61);
INSERT INTO t36 VALUES(7,71);
INSERT INTO t36 VALUES(8,81);
INSERT INTO t36 VALUES(9,91);
INSERT INTO t36 VALUES(10,101);
COMMIT;
INSERT INTO t37 VALUES(1,11);
INSERT INTO t37 VALUES(2,21);
INSERT INTO t37 VALUES(3,31);
INSERT INTO t37 VALUES(4,41);
INSERT INTO t37 VALUES(5,51);
INSERT INTO t37 VALUES(6,61);
INSERT INTO t37 VALUES(7,71);
INSERT INTO t37 VALUES(8,81);
INSERT INTO t37 VALUES(9,91);
INSERT INTO t37 VALUES(10,101);
COMMIT;
INSERT INTO t38 VALUES(1,11);
INSERT INTO t38 VALUES(2,21);
INSERT INTO t38 VALUES(3,31);
INSERT INTO t38 VALUES(4,41);
INSERT INTO t38 VALUES(5,51);
INSERT INTO t38 VALUES(6,61);
INSERT INTO t38 VALUES(7,71);
INSERT INTO t38 VALUES(8,81);
INSERT INTO t38 VALUES(9,91);
INSERT INTO t38 VALUES(10,101);
COMMIT;
INSERT INTO t39 VALUES(1,11);
INSERT INTO t39 VALUES(2,21);
INSERT INTO t39 VALUES(3,31);
INSERT INTO t39 VALUES(4,41);
INSERT INTO t39 VALUES(5,51);
INSERT INTO t39 VALUES(6,61);
INSERT INTO t39 VALUES(7,71);
INSERT INTO t39 VALUES(8,81);
INSERT INTO t39 VALUES(9,91);
INSERT INTO t39 VALUES(10,101);
COMMIT;
INSERT INTO t40 VALUES(1,11);
INSERT INTO t40 VALUES(2,21);
INSERT INTO t40 VALUES(3,31);
INSERT INTO t40 VALUES(4,41);
INSERT INTO t40 VALUES(5,51);
INSERT INTO t40 VALUES(6,61);
INSERT INTO t40 VALUES(7,71);
INSERT INTO t40 VALUES(8,81);
INSERT INTO t40 VALUES(9,91);
INSERT INTO t40 VALUES(10,101);
COMMIT;
INSERT INTO t41 VALUES(1,11);
INSERT INTO t41 VALUES(2,21);
INSERT INTO t41 VALUES(3,31);
INSERT INTO t41 VALUES(4,41);
INSERT INTO t41 VALUES(5,51);
INSERT INTO t41 VALUES(6,61);
INSERT INTO t41 VALUES(7,71);
INSERT INTO t41 VALUES(8,81);
INSERT INTO t41 VALUES(9,91);
INSERT INTO t41 VALUES(10,101);
COMMIT;
INSERT INTO t42 VALUES(1,11);
INSERT INTO t42 VALUES(2,21);
INSERT INTO t42 VALUES(3,31);
INSERT INTO t42 VALUES(4,41);
INSERT INTO t42 VALUES(5,51);
INSERT INTO t42 VALUES(6,61);
INSERT INTO t42 VALUES(7,71);
INSERT INTO t42 VALUES(8,81);
INSERT INTO t42 VALUES(9,91);
INSERT INTO t42 VALUES(10,101);
COMMIT;
INSERT INTO t43 VALUES(1,11);
INSERT INTO t43 VALUES(2,21);
INSERT INTO t43 VALUES(3,31);
INSERT INTO t43 VALUES(4,41);
INSERT INTO t43 VALUES(5,51);
INSERT INTO t43 VALUES(6,61);
INSERT INTO t43 VALUES(7,71);
INSERT INTO t43 VALUES(8,81);
INSERT INTO t43 VALUES(9,91);
INSERT INTO t43 VALUES(10,101);
COMMIT;
INSERT INTO t44 VALUES(1,11);
INSERT INTO t44 VALUES(2,21);
INSERT INTO t44 VALUES(3,31);
INSERT INTO t44 VALUES(4,41);
INSERT INTO t44 VALUES(5,51);
INSERT INTO t44 VALUES(6,61);
INSERT INTO t44 VALUES(7,71);
INSERT INTO t44 VALUES(8,81);
INSERT INTO t44 VALUES(9,91);
INSERT INTO t44 VALUES(10,101);
COMMIT;
INSERT INTO t45 VALUES(1,11);
INSERT INTO t45 VALUES(2,21);
INSERT INTO t45 VALUES(3,31);
INSERT INTO t45 VALUES(4,41);
INSERT INTO t45 VALUES(5,51);
INSERT INTO t45 VALUES(6,61);
INSERT INTO t45 VALUES(7,71);
INSERT INTO t45 VALUES(8,81);
INSERT INTO t45 VALUES(9,91);
INSERT INTO t45 VALUES(10,101);
COMMIT;
INSERT INTO t46 VALUES(1,11);
INSERT INTO t46 VALUES(2,21);
INSERT INTO t46 VALUES(3,31);
INSERT INTO t46 VALUES(4,41);
INSERT INTO t46 VALUES(5,51);
INSERT INTO t46 VALUES(6,61);
INSERT INTO t46 VALUES(7,71);
INSERT INTO t46 VALUES(8,81);
INSERT INTO t46 VALUES(9,91);
INSERT INTO t46 VALUES(10,101);
COMMIT;
INSERT INTO t47 VALUES(1,11);
INSERT INTO t47 VALUES(2,21);
INSERT INTO t47 VALUES(3,31);
INSERT INTO t47 VALUES(4,41);
INSERT INTO t47 VALUES(5,51);
INSERT INTO t47 VALUES(6,61);
INSERT INTO t47 VALUES(7,71);
INSERT INTO t47 VALUES(8,81);
INSERT INTO t47 VALUES(9,91);
INSERT INTO t47 VALUES(10,101);
COMMIT;
INSERT INTO t48 VALUES(1,11);
INSERT INTO t48 VALUES(2,21);
INSERT INTO t48 VALUES(3,31);
INSERT INTO t48 VALUES(4,41);
INSERT INTO t48 VALUES(5,51);
INSERT INTO t48 VALUES(6,61);
INSERT INTO t48 VALUES(7,71);
INSERT INTO t48 VALUES(8,81);
INSERT INTO t48 VALUES(9,91);
INSERT INTO t48 VALUES(10,101);
COMMIT;
INSERT INTO t49 VALUES(1,11);
INSERT INTO t49 VALUES(2,21);
INSERT INTO t49 VALUES(3,31);
INSERT INTO t49 VALUES(4,41);
INSERT INTO t49 VALUES(5,51);
INSERT INTO t49 VALUES(6,61);
INSERT INTO t49 VALUES(7,71);
INSERT INTO t49 VALUES(8,81);
INSERT INTO t49 VALUES(9,91);
INSERT INTO t49 VALUES(10,101);
COMMIT;
INSERT INTO t50 VALUES(1,11);
INSERT INTO t50 VALUES(2,21);
INSERT INTO t50 VALUES(3,31);
INSERT INTO t50 VALUES(4,41);
INSERT INTO t50 VALUES(5,51);
INSERT INTO t50 VALUES(6,61);
INSERT INTO t50 VALUES(7,71);
INSERT INTO t50 VALUES(8,81);
INSERT INTO t50 VALUES(9,91);
INSERT INTO t50 VALUES(10,101);
COMMIT;
INSERT INTO t51 VALUES(1,11);
INSERT INTO t51 VALUES(2,21);
INSERT INTO t51 VALUES(3,31);
INSERT INTO t51 VALUES(4,41);
INSERT INTO t51 VALUES(5,51);
INSERT INTO t51 VALUES(6,61);
INSERT INTO t51 VALUES(7,71);
INSERT INTO t51 VALUES(8,81);
INSERT INTO t51 VALUES(9,91);
INSERT INTO t51 VALUES(10,101);
COMMIT;
INSERT INTO t52 VALUES(1,11);
INSERT INTO t52 VALUES(2,21);
INSERT INTO t52 VALUES(3,31);
INSERT INTO t52 VALUES(4,41);
INSERT INTO t52 VALUES(5,51);
INSERT INTO t52 VALUES(6,61);
INSERT INTO t52 VALUES(7,71);
INSERT INTO t52 VALUES(8,81);
INSERT INTO t52 VALUES(9,91);
INSERT INTO t52 VALUES(10,101);
COMMIT;
INSERT INTO t53 VALUES(1,11);
INSERT INTO t53 VALUES(2,21);
INSERT INTO t53 VALUES(3,31);
INSERT INTO t53 VALUES(4,41);
INSERT INTO t53 VALUES(5,51);
INSERT INTO t53 VALUES(6,61);
INSERT INTO t53 VALUES(7,71);
INSERT INTO t53 VALUES(8,81);
INSERT INTO t53 VALUES(9,91);
INSERT INTO t53 VALUES(10,101);
COMMIT;
INSERT INTO t54 VALUES(1,11);
INSERT INTO t54 VALUES(2,21);
INSERT INTO t54 VALUES(3,31);
INSERT INTO t54 VALUES(4,41);
INSERT INTO t54 VALUES(5,51);
INSERT INTO t54 VALUES(6,61);
INSERT INTO t54 VALUES(7,71);
INSERT INTO t54 VALUES(8,81);
INSERT INTO t54 VALUES(9,91);
INSERT INTO t54 VALUES(10,101);
COMMIT;
INSERT INTO t55 VALUES(1,11);
INSERT INTO t55 VALUES(2,21);
INSERT INTO t55 VALUES(3,31);
INSERT INTO t55 VALUES(4,41);
INSERT INTO t55 VALUES(5,51);
INSERT INTO t55 VALUES(6,61);
INSERT INTO t55 VALUES(7,71);
INSERT INTO t55 VALUES(8,81);
INSERT INTO t55 VALUES(9,91);
INSERT INTO t55 VALUES(10,101);
COMMIT;
INSERT INTO t56 VALUES(1,11);
INSERT INTO t56 VALUES(2,21);
INSERT INTO t56 VALUES(3,31);
INSERT INTO t56 VALUES(4,41);
INSERT INTO t56 VALUES(5,51);
INSERT INTO t56 VALUES(6,61);
INSERT INTO t56 VALUES(7,71);
INSERT INTO t56 VALUES(8,81);
INSERT INTO t56 VALUES(9,91);
INSERT INTO t56 VALUES(10,101);
COMMIT;
INSERT INTO t57 VALUES(1,11);
INSERT INTO t57 VALUES(2,21);
INSERT INTO t57 VALUES(3,31);
INSERT INTO t57 VALUES(4,41);
INSERT INTO t57 VALUES(5,51);
INSERT INTO t57 VALUES(6,61);
INSERT INTO t57 VALUES(7,71);
INSERT INTO t57 VALUES(8,81);
INSERT INTO t57 VALUES(9,91);
INSERT INTO t57 VALUES(10,101);
COMMIT;
INSERT INTO t58 VALUES(1,11);
INSERT INTO t58 VALUES(2,21);
INSERT INTO t58 VALUES(3,31);
INSERT INTO t58 VALUES(4,41);
INSERT INTO t58 VALUES(5,51);
INSERT INTO t58 VALUES(6,61);
INSERT INTO t58 VALUES(7,71);
INSERT INTO t58 VALUES(8,81);
INSERT INTO t58 VALUES(9,91);
INSERT INTO t58 VALUES(10,101);
COMMIT;
INSERT INTO t59 VALUES(1,11);
INSERT INTO t59 VALUES(2,21);
INSERT INTO t59 VALUES(3,31);
INSERT INTO t59 VALUES(4,41);
INSERT INTO t59 VALUES(5,51);
INSERT INTO t59 VALUES(6,61);
INSERT INTO t59 VALUES(7,71);
INSERT INTO t59 VALUES(8,81);
INSERT INTO t59 VALUES(9,91);
INSERT INTO t59 VALUES(10,101);
COMMIT;
INSERT INTO t60 VALUES(1,11);
INSERT INTO t60 VALUES(2,21);
INSERT INTO t60 VALUES(3,31);
INSERT INTO t60 VALUES(4,41);
INSERT INTO t60 VALUES(5,51);
INSERT INTO t60 VALUES(6,61);
INSERT INTO t60 VALUES(7,71);
INSERT INTO t60 VALUES(8,81);
INSERT INTO t60 VALUES(9,91);
INSERT INTO t60 VALUES(10,101);
COMMIT;
INSERT INTO t61 VALUES(1,11);
INSERT INTO t61 VALUES(2,21);
INSERT INTO t61 VALUES(3,31);
INSERT INTO t61 VALUES(4,41);
INSERT INTO t61 VALUES(5,51);
INSERT INTO t61 VALUES(6,61);
INSERT INTO t61 VALUES(7,71);