inputtest008.sql

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

create table kishor(fld1 int, name1 char(30), primary key (fld1));
insert into kishor values(11, 'raksha1');
insert into kishor values(2, 'Laxkshya2');
insert into kishor values(32, 'Laksxhya3');
insert into kishor values(4, 'Lakhya4');
insert into kishor values(5, 'Laka5');
insert into kishor values(63, 'shya6');
insert into kishor values(7, 'Laksya7');
insert into kishor values(18, 'Lakya8');
insert into kishor values(97, 'Lakhya9');
insert into kishor values(104, 'Laa10');
create table ravi(fld2 int, name1 char(30), primary key (fld2));
insert into ravi values(11, 'Lakshy');
insert into ravi values(22, 'raksha2');
insert into ravi values(33, 'raksha3');
insert into ravi values(44, 'Lak4');
insert into ravi values(55, 'raksha5');
insert into ravi values(66, 'Lakya6');
insert into ravi values(77, 'raksha7');
insert into ravi values(88, 'Laksa8');
insert into ravi values(99, 'Laksya9');
insert into ravi values(100, 'Lashya10');
create table kiran(fld3 int, name1 char(30), primary key (fld3));
insert into kiran values(31, 'raksha1');
insert into kiran values(42, 'Lakshya2');
insert into kiran values(53, 'raksha3');
insert into kiran values(64, 'Lakshya4');
insert into kiran values(58, 'raksha5');
insert into kiran values(63, 'Lakshya6');
insert into kiran values(74, 'raksha7');
insert into kiran values(87, 'Lakshya8');
insert into kiran values(94, 'raksha9');
insert into kiran values(10, 'Lakshya10');
create table anand(fld4 int, name1 char(30), primary key (fld4));
insert into anand values(12, 'Lakshya1');
insert into anand values(23, 'raksha2');
insert into anand values(35, 'Lakshya3');
insert into anand values(48, 'Lakshya4');
insert into anand values(53, 'raksha5');
insert into anand values(66, 'Lakshya6');
insert into anand values(79, 'Lakshya7');
insert into anand values(81, 'raksha8');
insert into anand values(94, 'Lakshya9');
insert into anand values(105, 'Lakshya10');
create table vikas(fld5 int, name1 char(30), primary key (fld5));
insert into vikas values(1, 'Lakshya1');
insert into vikas values(2, 'Lakshya2');
insert into vikas values(3, 'raksha3');
insert into vikas values(4, 'Lakshya4');
insert into vikas values(5, 'Lakshya5');
insert into vikas values(6, 'Lakshya6');
insert into vikas values(7, 'Lakshya7');
insert into vikas values(8, 'Lakshya8');
insert into vikas values(9, 'raksha9');
insert into vikas values(10, 'Lakshya10');
create table vikram(fld6 int, name1 char(30), primary key (fld6));
insert into vikram values(1, 'Lakshya1');
insert into vikram values(2, 'raksha2');
insert into vikram values(3, 'Lakshya3');
insert into vikram values(4, 'raksha4');
insert into vikram values(5, 'Lakshya5');
insert into vikram values(6, 'Lakshya6');
insert into vikram values(7, 'raksha7');
insert into vikram values(8, 'Lakshya8');
insert into vikram values(9, 'Lakshya9');
insert into vikram values(10, 'Lakshya10');
create table vinod(fld7 int, name1 char(30), primary key (fld7));
insert into vinod values(1, 'Lakshya1');
insert into vinod values(2, 'raksha2');
insert into vinod values(3, 'Lakshya3');
insert into vinod values(4, 'Lakshya4');
insert into vinod values(5, 'raksha5');
insert into vinod values(6, 'Lakshya6');
insert into vinod values(7, 'Lakshya7');
insert into vinod values(8, 'raksha8');
insert into vinod values(9, 'Lakshya9');
insert into vinod values(10, 'Lakshya10');
create table jayant(fld8 int, name1 char(30), primary key (fld8));
insert into jayant values(1, 'Lakshya1');
insert into jayant values(2, 'raksha2');
insert into jayant values(3, 'Lakshya3');
insert into jayant values(4, 'Lakshya4');
insert into jayant values(5, 'raksha5');
insert into jayant values(6, 'Lakshya6');
insert into jayant values(7, 'Lakshya7');
insert into jayant values(8, 'raksha8');
insert into jayant values(9, 'Lakshya9');
insert into jayant values(10, 'Lakshya10');
create table rahul(fld9 int, name1 char(30), primary key (fld9));
insert into rahul values(1, 'Lakshya1');
insert into rahul values(2, 'Lakshya2');
insert into rahul values(3, 'raksha3');
insert into rahul values(4, 'Lakshya4');
insert into rahul values(5, 'Lakshya5');
insert into rahul values(6, 'raksha6');
insert into rahul values(7, 'Lakshya7');
insert into rahul values(8, 'Lakshya8');
insert into rahul values(9, 'Lakshya9');
insert into rahul values(10, 'Lakshya10');
create table ramesh(fld10 int, name1 char(30), primary key (fld10));
insert into ramesh values(1, 'Lakshya1');
insert into ramesh values(2, 'Lakshya2');
insert into ramesh values(3, 'Lakshya3');
insert into ramesh values(4, 'Lakshya4');
insert into ramesh values(5, 'Lakshya5');
insert into ramesh values(6, 'raksha6');
insert into ramesh values(7, 'raksha7');
insert into ramesh values(8, 'raksha8');
insert into ramesh values(9, 'raksha9');
insert into ramesh values(10, 'Lakshya10');