-
Notifications
You must be signed in to change notification settings - Fork 2
/
populate.sql
29 lines (28 loc) · 5.96 KB
/
populate.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
INSERT INTO APP.BOOK (ID, TITLE, CONTENTLANGUAGE, PRICE, ILLUSTRATIONS, DESCRIPTION, ISBN, NBOFPAGE)VALUES (887,'The Hitchhiker''s Guide to the Galaxy','EN', 23.99, 1, 'Science fiction comedy book', '1-84023-742-2', 354);
INSERT INTO APP.BOOK (ID, TITLE, CONTENTLANGUAGE, PRICE, ILLUSTRATIONS, DESCRIPTION, ISBN, NBOFPAGE)VALUES (152,'Harry Potter and the Goblet of Fire','EN', 19.79, 0, 'Science fiction (Book 4)', '1-978-0439139595', 734);
INSERT INTO APP.BOOK (ID, TITLE, CONTENTLANGUAGE, PRICE, ILLUSTRATIONS, DESCRIPTION, ISBN, NBOFPAGE)VALUES (919,'The Elements of Style','EN', 6.64, 1, 'A masterpiece in the art of clear and concise writing.', '1-978-0205309023', 105);
INSERT INTO APP.BOOK (ID, TITLE, CONTENTLANGUAGE, PRICE, ILLUSTRATIONS, DESCRIPTION, ISBN, NBOFPAGE)VALUES (127,'Harry Potter And The Order Of The Phoenix','EN', 9.35, 0, 'Science fiction (Book 1)', '1-978-0439358071', 870);
INSERT INTO APP.BOOK (ID, TITLE, CONTENTLANGUAGE, PRICE, ILLUSTRATIONS, DESCRIPTION, ISBN, NBOFPAGE)VALUES (911,'The Difference Between God and Larry Ellison','EN', 11.99, 1, 'God Doesn''t Think He''s Larry Ellison', '1-978-0060008765', 420);
INSERT INTO APP.BOOK (ID, TITLE, CONTENTLANGUAGE, PRICE, ILLUSTRATIONS, DESCRIPTION, ISBN, NBOFPAGE)VALUES (401,'The Children of Hurin','EN', 17.16, 1, 'The first complete book by J.R.R. Tolkien in three decades', '1-978-0618894642', 313);
INSERT INTO APP.BOOK (ID, TITLE, CONTENTLANGUAGE, PRICE, ILLUSTRATIONS, DESCRIPTION, ISBN, NBOFPAGE)VALUES (719,'The Da Vinci Code','EN', 17.79, 1, 'Thriller', '1-978-0385504201', 454);
INSERT INTO APP.BOOK (ID, TITLE, CONTENTLANGUAGE, PRICE, ILLUSTRATIONS, DESCRIPTION, ISBN, NBOFPAGE)VALUES (111,'La carte et le territoire','FR', 24.99, 0, 'Prix Goncourt 2010', '1-978-2081246331', 428);
INSERT INTO APP.BOOK (ID, TITLE, CONTENTLANGUAGE, PRICE, ILLUSTRATIONS, DESCRIPTION, ISBN, NBOFPAGE)VALUES (771,'Une forme de vie','FR', 18.99, 0, 'Amelie Nothomb', '1-978-2226215178', 168);
INSERT INTO APP.BOOK (ID, TITLE, CONTENTLANGUAGE, PRICE, ILLUSTRATIONS, DESCRIPTION, ISBN, NBOFPAGE)VALUES (119,'To Kill a Mockingbird','EN', 5.99, 0, 'American classic', '1-978-0446310789', 281);
INSERT INTO APP.BOOK (ID, TITLE, CONTENTLANGUAGE, PRICE, ILLUSTRATIONS, DESCRIPTION, ISBN, NBOFPAGE)VALUES (716,'Fahrenheit 451','EN', 7.99, 0, 'Science fiction', '1-978-0345342966', 208);
INSERT INTO APP.BOOK (ID, TITLE, CONTENTLANGUAGE, PRICE, ILLUSTRATIONS, DESCRIPTION, ISBN, NBOFPAGE)VALUES (822,'Lolita','RU', 14.99, 1, 'Nabovok masterpiece', '1-978-0141023496', 368);
INSERT INTO APP.BOOK (ID, TITLE, CONTENTLANGUAGE, PRICE, ILLUSTRATIONS, DESCRIPTION, ISBN, NBOFPAGE)VALUES (899,'A Midsummer Night''s Dream','EN', 14.99, 0, 'Shakespeare masterpiece', '1-978-0199535866', 288);
INSERT INTO APP.BOOK (ID, TITLE, CONTENTLANGUAGE, PRICE, ILLUSTRATIONS, DESCRIPTION, ISBN, NBOFPAGE)VALUES (987,'I bastioni del coraggio','IT', 18.99, 1, 'Anno domini 1548. Una grande storia d''amore, ...', '1-978-88045844', 457);
INSERT INTO APP.BOOK (ID, TITLE, CONTENTLANGUAGE, PRICE, ILLUSTRATIONS, DESCRIPTION, ISBN, NBOFPAGE)VALUES (827,'Harjunpää ja pahan pappi','FI', 32.49, 0, 'Finns read crime novels', '1-978-951-1-2-4742-5', 300);
INSERT INTO APP.BOOK (ID, TITLE, CONTENTLANGUAGE, PRICE, ILLUSTRATIONS, DESCRIPTION, ISBN, NBOFPAGE)VALUES (881,'El ingenioso hidalgo don Quijote de la Mancha','ES', 13.99, 0, 'Classical Don Quijote', '1-842-4116194', 108);
INSERT INTO APP.BOOK (ID, TITLE, CONTENTLANGUAGE, PRICE, ILLUSTRATIONS, DESCRIPTION, ISBN, NBOFPAGE)VALUES (199,'The Lord of the Rings','EN', 50.4, 1, 'Science fiction comedy book', '1-978-061-8-2-6058-4', 1216);
INSERT INTO APP.BOOK (ID, TITLE, CONTENTLANGUAGE, PRICE, ILLUSTRATIONS, DESCRIPTION, ISBN, NBOFPAGE)VALUES (287,'Java EE 6 with GlassFish 3','EN', 31.49, 1, 'Java!', '1-978-1430228899', 354);
INSERT INTO APP.BOOK (ID, TITLE, CONTENTLANGUAGE, PRICE, ILLUSTRATIONS, DESCRIPTION, ISBN, NBOFPAGE)VALUES (337,'Heidis Lehr- und Wanderjahre','DE', 68, 1, 'Inhalt: Die Heidi-Bücher erzählen...', '1-978-1452826226', 160);
INSERT INTO APP.BOOK (ID, TITLE, CONTENTLANGUAGE, PRICE, ILLUSTRATIONS, DESCRIPTION, ISBN, NBOFPAGE)VALUES (387,'l Nome della Rosa','IT', 34.99, 0, 'Science fiction comedy book', '1-884-5214214', 354);
INSERT INTO APP.CD (ID, NUMBEROFCDS, TITLE, TOTALDURATION, PRICE, STYLE, DESCRIPTION ,MUSICCOMPANY) VALUES (119, 1, 'Genesis', 45.59, 18.28, 'Pop rock', 'Genesis are an English rock band that formed in 1967', 'Atlantic');
INSERT INTO APP.CD (ID, NUMBEROFCDS, TITLE, TOTALDURATION, PRICE, STYLE, DESCRIPTION ,MUSICCOMPANY) VALUES (312, 1, 'The Dark Side of the Moon', 42.59, 14.99, 'Progressive rock', 'Pink Floyd were an English rock band', 'EMI');
INSERT INTO APP.CD (ID, NUMBEROFCDS, TITLE, TOTALDURATION, PRICE, STYLE, DESCRIPTION ,MUSICCOMPANY) VALUES (413, 1, 'Minor Swing', 3.18, 1.99, 'Gypsy jazz', 'Pioneering virtuoso jazz guitarist and composer', 'None');
INSERT INTO APP.CD (ID, NUMBEROFCDS, TITLE, TOTALDURATION, PRICE, STYLE, DESCRIPTION ,MUSICCOMPANY) VALUES (986, 2, 'Simon and Garfunkel in Central Park', 75.51, 23.99, 'Folk rock', ' Live album recorded on September 19, 1981', 'Warner Bros.');
INSERT INTO APP.CD (ID, NUMBEROFCDS, TITLE, TOTALDURATION, PRICE, STYLE, DESCRIPTION ,MUSICCOMPANY) VALUES (124, 1, 'Blue Monday', 7.29, 1.99, 'New Wave', 'New Order''s longest tracks ever to chart', 'Factory');
INSERT INTO APP.CD (ID, NUMBEROFCDS, TITLE, TOTALDURATION, PRICE, STYLE, DESCRIPTION ,MUSICCOMPANY) VALUES (231, 1, 'The Unforgettable Fire', 42.38, 13.99, 'Rock', 'The Unforgettable Fire is the fourth studio album by Irish rock band U2', 'Island');
INSERT INTO APP.CD (ID, NUMBEROFCDS, TITLE, TOTALDURATION, PRICE, STYLE, DESCRIPTION ,MUSICCOMPANY) VALUES (992, 1, 'Synchronicity', 44.32, 15.99, 'Pop rock', 'Fifth and final studio album by The Police, released in 1983', 'A&M');
INSERT INTO APP.CD (ID, NUMBEROFCDS, TITLE, TOTALDURATION, PRICE, STYLE, DESCRIPTION ,MUSICCOMPANY) VALUES (392, 2, 'Bireli Lagrene & Gypsy Project', 58.12, 16.98, 'Gypsy jazz', 'has perhaps inherited more of Django''s musical spirit', 'Dreyfus');