sampledata.sql

hsqldb是100％java实现的数据库,是一个开放源代码的JAVA数据库 l 具有标准的SQL语法和JAVA接口 l HSQLDB可以自由使用和分发 l 非常简洁和快速的

INSERT INTO Invoice VALUES(15,39,0.0);
INSERT INTO Item VALUES(15,2,24,6,1.5);
INSERT INTO Item VALUES(15,1,13,21,1.5);
INSERT INTO Item VALUES(15,0,17,12,1.5);
INSERT INTO Customer VALUES(16,'John','Fuller','195 Seventh Av.','New York');
INSERT INTO Product VALUES(16,'Ice Tea Shoe',194);
INSERT INTO Invoice VALUES(16,45,0.0);
INSERT INTO Item VALUES(16,15,12,3,1.5);
INSERT INTO Item VALUES(16,14,0,19,1.5);
INSERT INTO Item VALUES(16,13,20,1,1.5);
INSERT INTO Item VALUES(16,12,18,2,1.5);
INSERT INTO Item VALUES(16,11,24,7,1.5);
INSERT INTO Item VALUES(16,10,43,8,1.5);
INSERT INTO Item VALUES(16,9,11,10,1.5);
INSERT INTO Item VALUES(16,8,13,17,1.5);
INSERT INTO Item VALUES(16,7,8,17,1.5);
INSERT INTO Item VALUES(16,6,44,7,1.5);
INSERT INTO Item VALUES(16,5,11,15,1.5);
INSERT INTO Item VALUES(16,4,10,24,1.5);
INSERT INTO Item VALUES(16,3,0,3,1.5);
INSERT INTO Item VALUES(16,2,20,15,1.5);
INSERT INTO Item VALUES(16,1,36,20,1.5);
INSERT INTO Item VALUES(16,0,18,15,1.5);
INSERT INTO Customer VALUES(17,'Laura','Ott','443 Seventh Av.','Lyon');
INSERT INTO Product VALUES(17,'Clock Ice Tea',220);
INSERT INTO Invoice VALUES(17,46,0.0);
INSERT INTO Item VALUES(17,19,46,12,1.5);
INSERT INTO Item VALUES(17,18,5,9,1.5);
INSERT INTO Item VALUES(17,17,7,5,1.5);
INSERT INTO Item VALUES(17,16,8,16,1.5);
INSERT INTO Item VALUES(17,15,35,10,1.5);
INSERT INTO Item VALUES(17,14,18,2,1.5);
INSERT INTO Item VALUES(17,13,41,5,1.5);
INSERT INTO Item VALUES(17,12,22,16,1.5);
INSERT INTO Item VALUES(17,11,45,10,1.5);
INSERT INTO Item VALUES(17,10,10,12,1.5);
INSERT INTO Item VALUES(17,9,8,15,1.5);
INSERT INTO Item VALUES(17,8,49,8,1.5);
INSERT INTO Item VALUES(17,7,6,15,1.5);
INSERT INTO Item VALUES(17,6,43,6,1.5);
INSERT INTO Item VALUES(17,5,44,1,1.5);
INSERT INTO Item VALUES(17,4,23,2,1.5);
INSERT INTO Item VALUES(17,3,24,4,1.5);
INSERT INTO Item VALUES(17,2,44,11,1.5);
INSERT INTO Item VALUES(17,1,19,19,1.5);
INSERT INTO Item VALUES(17,0,16,8,1.5);
INSERT INTO Customer VALUES(18,'Sylvia','Fuller','158 - 20th Ave.','Paris');
INSERT INTO Product VALUES(18,'Chair Clock',172);
INSERT INTO Invoice VALUES(18,4,0.0);
INSERT INTO Item VALUES(18,18,10,1,1.5);
INSERT INTO Item VALUES(18,17,8,1,1.5);
INSERT INTO Item VALUES(18,16,31,12,1.5);
INSERT INTO Item VALUES(18,15,44,20,1.5);
INSERT INTO Item VALUES(18,14,28,20,1.5);
INSERT INTO Item VALUES(18,13,14,12,1.5);
INSERT INTO Item VALUES(18,12,37,12,1.5);
INSERT INTO Item VALUES(18,11,30,8,1.5);
INSERT INTO Item VALUES(18,10,34,18,1.5);
INSERT INTO Item VALUES(18,9,2,2,1.5);
INSERT INTO Item VALUES(18,8,1,24,1.5);
INSERT INTO Item VALUES(18,7,15,14,1.5);
INSERT INTO Item VALUES(18,6,29,4,1.5);
INSERT INTO Item VALUES(18,5,15,6,1.5);
INSERT INTO Item VALUES(18,4,28,6,1.5);
INSERT INTO Item VALUES(18,3,19,8,1.5);
INSERT INTO Item VALUES(18,2,40,12,1.5);
INSERT INTO Item VALUES(18,1,33,12,1.5);
INSERT INTO Item VALUES(18,0,32,1,1.5);
INSERT INTO Customer VALUES(19,'Susanne','Heiniger','86 - 20th Ave.','Dallas');
INSERT INTO Product VALUES(19,'Ice Tea Ice Tea',110);
INSERT INTO Invoice VALUES(19,9,0.0);
INSERT INTO Item VALUES(19,4,36,24,1.5);
INSERT INTO Item VALUES(19,3,49,23,1.5);
INSERT INTO Item VALUES(19,2,4,22,1.5);
INSERT INTO Item VALUES(19,1,31,2,1.5);
INSERT INTO Item VALUES(19,0,12,7,1.5);
INSERT INTO Customer VALUES(20,'Janet','Schneider','309 - 20th Ave.','Oslo');
INSERT INTO Product VALUES(20,'Ice Tea Telephone',200);
INSERT INTO Invoice VALUES(20,19,0.0);
INSERT INTO Item VALUES(20,11,15,8,1.5);
INSERT INTO Item VALUES(20,10,25,11,1.5);
INSERT INTO Item VALUES(20,9,12,8,1.5);
INSERT INTO Item VALUES(20,8,44,18,1.5);
INSERT INTO Item VALUES(20,7,9,9,1.5);
INSERT INTO Item VALUES(20,6,20,2,1.5);
INSERT INTO Item VALUES(20,5,8,14,1.5);
INSERT INTO Item VALUES(20,4,30,13,1.5);
INSERT INTO Item VALUES(20,3,25,14,1.5);
INSERT INTO Item VALUES(20,2,24,22,1.5);
INSERT INTO Item VALUES(20,1,29,6,1.5);
INSERT INTO Item VALUES(20,0,47,15,1.5);
INSERT INTO Customer VALUES(21,'Julia','Clancy','18 Seventh Av.','Seattle');
INSERT INTO Product VALUES(21,'Chair Chair',114);
INSERT INTO Invoice VALUES(21,8,0.0);
INSERT INTO Item VALUES(21,11,20,11,1.5);
INSERT INTO Item VALUES(21,10,19,14,1.5);
INSERT INTO Item VALUES(21,9,35,17,1.5);
INSERT INTO Item VALUES(21,8,44,19,1.5);
INSERT INTO Item VALUES(21,7,8,9,1.5);
INSERT INTO Item VALUES(21,6,26,7,1.5);
INSERT INTO Item VALUES(21,5,27,18,1.5);
INSERT INTO Item VALUES(21,4,49,22,1.5);
INSERT INTO Item VALUES(21,3,30,13,1.5);
INSERT INTO Item VALUES(21,2,31,17,1.5);
INSERT INTO Item VALUES(21,1,38,19,1.5);
INSERT INTO Item VALUES(21,0,9,10,1.5);
INSERT INTO Customer VALUES(22,'Bill','Ott','250 - 20th Ave.','Berne');
INSERT INTO Product VALUES(22,'Iron Iron',66);
INSERT INTO Invoice VALUES(22,40,0.0);
INSERT INTO Item VALUES(22,9,23,1,1.5);
INSERT INTO Item VALUES(22,8,3,2,1.5);
INSERT INTO Item VALUES(22,7,21,6,1.5);
INSERT INTO Item VALUES(22,6,4,11,1.5);
INSERT INTO Item VALUES(22,5,24,5,1.5);
INSERT INTO Item VALUES(22,4,5,21,1.5);
INSERT INTO Item VALUES(22,3,22,5,1.5);
INSERT INTO Item VALUES(22,2,12,20,1.5);
INSERT INTO Item VALUES(22,1,30,11,1.5);
INSERT INTO Item VALUES(22,0,9,6,1.5);
INSERT INTO Customer VALUES(23,'Julia','Heiniger','358 College Av.','Boston');
INSERT INTO Product VALUES(23,'Shoe Chair',76);
INSERT INTO Invoice VALUES(23,36,0.0);
INSERT INTO Item VALUES(23,16,8,11,1.5);
INSERT INTO Item VALUES(23,15,13,17,1.5);
INSERT INTO Item VALUES(23,14,44,2,1.5);
INSERT INTO Item VALUES(23,13,14,17,1.5);
INSERT INTO Item VALUES(23,12,4,17,1.5);
INSERT INTO Item VALUES(23,11,41,8,1.5);
INSERT INTO Item VALUES(23,10,4,18,1.5);
INSERT INTO Item VALUES(23,9,20,18,1.5);
INSERT INTO Item VALUES(23,8,6,17,1.5);
INSERT INTO Item VALUES(23,7,39,3,1.5);
INSERT INTO Item VALUES(23,6,16,1,1.5);
INSERT INTO Item VALUES(23,5,32,14,1.5);
INSERT INTO Item VALUES(23,4,23,19,1.5);
INSERT INTO Item VALUES(23,3,40,19,1.5);
INSERT INTO Item VALUES(23,2,33,18,1.5);
INSERT INTO Item VALUES(23,1,26,8,1.5);
INSERT INTO Item VALUES(23,0,48,22,1.5);
INSERT INTO Customer VALUES(24,'James','Sommer','333 Upland Pl.','Olten');
INSERT INTO Product VALUES(24,'Chair Shoe',72);
INSERT INTO Invoice VALUES(24,15,0.0);
INSERT INTO Item VALUES(24,15,39,17,1.5);
INSERT INTO Item VALUES(24,14,1,13,1.5);
INSERT INTO Item VALUES(24,13,15,21,1.5);
INSERT INTO Item VALUES(24,12,0,8,1.5);
INSERT INTO Item VALUES(24,11,1,4,1.5);
INSERT INTO Item VALUES(24,10,27,4,1.5);
INSERT INTO Item VALUES(24,9,21,8,1.5);
INSERT INTO Item VALUES(24,8,5,18,1.5);
INSERT INTO Item VALUES(24,7,7,13,1.5);
INSERT INTO Item VALUES(24,6,40,3,1.5);
INSERT INTO Item VALUES(24,5,35,16,1.5);
INSERT INTO Item VALUES(24,4,15,17,1.5);
INSERT INTO Item VALUES(24,3,17,23,1.5);
INSERT INTO Item VALUES(24,2,38,10,1.5);
INSERT INTO Item VALUES(24,1,46,18,1.5);
INSERT INTO Item VALUES(24,0,43,14,1.5);
INSERT INTO Customer VALUES(25,'Sylvia','Steel','269 College Av.','Paris');
INSERT INTO Product VALUES(25,'Shoe Shoe',162);
INSERT INTO Invoice VALUES(25,31,0.0);
INSERT INTO Item VALUES(25,8,38,3,1.5);
INSERT INTO Item VALUES(25,7,16,8,1.5);
INSERT INTO Item VALUES(25,6,21,18,1.5);
INSERT INTO Item VALUES(25,5,10,5,1.5);
INSERT INTO Item VALUES(25,4,47,10,1.5);
INSERT INTO Item VALUES(25,3,19,4,1.5);
INSERT INTO Item VALUES(25,2,13,8,1.5);
INSERT INTO Item VALUES(25,1,43,13,1.5);
INSERT INTO Item VALUES(25,0,5,15,1.5);
INSERT INTO Customer VALUES(26,'James','Clancy','195 Upland Pl.','Oslo');
INSERT INTO Product VALUES(26,'Shoe Shoe',252);
INSERT INTO Invoice VALUES(26,27,0.0);
INSERT INTO Item VALUES(26,16,30,4,1.5);
INSERT INTO Item VALUES(26,15,8,6,1.5);
INSERT INTO Item VALUES(26,14,26,6,1.5);
INSERT INTO Item VALUES(26,13,13,10,1.5);
INSERT INTO Item VALUES(26,12,27,20,1.5);
INSERT INTO Item VALUES(26,11,18,3,1.5);
INSERT INTO Item VALUES(26,10,34,16,1.5);
INSERT INTO Item VALUES(26,9,1,23,1.5);
INSERT INTO Item VALUES(26,8,40,13,1.5);
INSERT INTO Item VALUES(26,7,4,16,1.5);
INSERT INTO Item VALUES(26,6,7,23,1.5);
INSERT INTO Item VALUES(26,5,38,4,1.5);
INSERT INTO Item VALUES(26,4,46,7,1.5);
INSERT INTO Item VALUES(26,3,16,3,1.5);
INSERT INTO Item VALUES(26,2,33,7,1.5);
INSERT INTO Item VALUES(26,1,43,21,1.5);
INSERT INTO Item VALUES(26,0,42,16,1.5);
INSERT INTO Customer VALUES(27,'Bob','Sommer','509 College Av.','Seattle');
INSERT INTO Product VALUES(27,'Telephone Iron',230);
INSERT INTO Invoice VALUES(27,24,0.0);
INSERT INTO Item VALUES(27,2,19,1,1.5);
INSERT INTO Item VALUES(27,1,45,15,1.5);
INSERT INTO Item VALUES(27,0,24,15,1.5);
INSERT INTO Customer VALUES(28,'Susanne','White','74 - 20th Ave.','Lyon');
INSERT INTO Product VALUES(28,'Clock Iron',30);
INSERT INTO Invoice VALUES(28,35,0.0);
INSERT INTO Item VALUES(28,8,28,6,1.5);
INSERT INTO Item VALUES(28,7,28,8,1.5);
INSERT INTO Item VALUES(28,6,33,16,1.5);
INSERT INTO Item VALUES(28,5,49,4,1.5);
INSERT INTO Item VALUES(28,4,45,17,1.5);
INSERT INTO Item VALUES(28,3,6,3,1.5);
INSERT INTO Item VALUES(28,2,44,22,1.5);
INSERT INTO Item VALUES(28,1,15,13,1.5);
INSERT INTO Item VALUES(28,0,35,13,1.5);
INSERT INTO Customer VALUES(29,'Andrew','Smith','254 College Av.','New York');
INSERT INTO Product VALUES(29,'Chair Telephone',112);
INSERT INTO Invoice VALUES(29,46,0.0);
INSERT INTO Item VALUES(29,8,35,6,1.5);
INSERT INTO Item VALUES(29,7,5,1,1.5);
INSERT INTO Item VALUES(29,6,4,16,1.5);
INSERT INTO Item VALUES(29,5,31,13,1.5);
INSERT INTO Item VALUES(29,4,4,7,1.5);
INSERT INTO Item VALUES(29,3,7,21,1.5);
INSERT INTO Item VALUES(29,2,17,23,1.5);
INSERT INTO Item VALUES(29,1,38,12,1.5);
INSERT INTO Item VALUES(29,0,33,17,1.5);
INSERT INTO Customer VALUES(30,'Bill','Sommer','362 - 20th Ave.','Olten');
INSERT INTO Product VALUES(30,'Shoe Iron',232);
INSERT INTO Invoice VALUES(30,13,0.0);
INSERT INTO Item VALUES(30,6,14,23,1.5);
INSERT INTO Item VALUES(30,5,43,23,1.5);
INSERT INTO Item VALUES(30,4,34,2,1.5);
INSERT INTO Item VALUES(30,3,33,2,1.5);
INSERT INTO Item VALUES(30,2,10,18,1.5);
INSERT INTO Item VALUES(30,1,16,19,1.5);
INSERT INTO Item VALUES(30,0,14,7,1.5);
INSERT INTO Customer VALUES(31,'Bob','Ringer','371 College Av.','Olten');
INSERT INTO Product VALUES(31,'Ice Tea Telephone',48);
INSERT INTO Invoice VALUES(31,22,0.0);
INSERT INTO Item VALUES(31,10,0,3,1.5);
INSERT INTO Item VALUES(31,9,14,15,1.5);
INSERT INTO Item VALUES(31,8,7,5,1.5);
INSERT INTO Item VALUES(31,7,38,3,1.5);
INSERT INTO Item VALUES(31,6,26,16,1.5);
INSERT INTO Item VALUES(31,5,1,4,1.5);
INSERT INTO Item VALUES(31,4,8,14,1.5);
INSERT INTO Item VALUES(31,3,12,10,1.5);
INSERT INTO Item VALUES(31,2,4,3,1.5);
INSERT INTO Item VALUES(31,1,4,23,1.5);
INSERT INTO Item VALUES(31,0,33,10,1.5);
INSERT INTO Customer VALUES(32,'Michael','Ott','339 College Av.','Boston');
INSERT INTO Product VALUES(32,'Clock Iron',190);
INSERT INTO Invoice VALUES(32,20,0.0);
INSERT INTO Item VALUES(32,2,1,14,1.5);
INSERT INTO Item VALUES(32,1,30,13,1.5);
INSERT INTO Item VALUES(32,0,35,11,1.5);
INSERT INTO Customer VALUES(33,'Mary','King','491 College Av.','Oslo');
INSERT INTO Product VALUES(33,'Iron Chair',182);
INSERT INTO Invoice VALUES(33,40,0.0);
INSERT INTO Item VALUES(33,15,38,7,1.5);
INSERT INTO Item VALUES(33,14,44,13,1.5);
INSERT INTO Item VALUES(33,13,25,16,1.5);
INSERT INTO Item VALUES(33,12,16,23,1.5);
INSERT INTO Item VALUES(33,11,5,7,1.5);
INSERT INTO Item VALUES(33,10,24,9,1.5);
INSERT INTO Item VALUES(33,9,29,5,1.5);
INSERT INTO Item VALUES(33,8,3,15,1.5);
INSERT INTO Item VALUES(33,7,43,10,1.5);
INSERT INTO Item VALUES(33,6,17,16,1.5);
INSERT INTO Item VALUES(33,5,8,11,1.5);
INSERT INTO Item VALUES(33,4,24,1,1.5);
INSERT INTO Item VALUES(33,3,48,1,1.5);
INSERT INTO Item VALUES(33,2,36,16,1.5);
INSERT INTO Item VALUES(33,1,10,21,1.5);
INSERT INTO Item VALUES(33,0,36,5,1.5);
INSERT INTO Customer VALUES(34,'Julia','May','33 Upland Pl.','Seattle');
INSERT INTO Product VALUES(34,'Chair Iron',256);
INSERT INTO Invoice VALUES(34,33,0.0);
INSERT INTO Item VALUES(34,14,46,7,1.5);
INSERT INTO Item VALUES(34,13,30,14,1.5);
INSERT INTO Item VALUES(34,12,43,21,1.5);