Advertisement
shihabsikder

Sample products and wishlist

Apr 2nd, 2022 (edited)
1,437
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. create table product (
  2.     id INT,
  3.     product_name VARCHAR(50),
  4.     price_per_unit DECIMAL(5,2)
  5. );
  6. insert into product (id, product_name, price_per_unit) values (1, 'Tofu - Soft', 28.34);
  7. insert into product (id, product_name, price_per_unit) values (2, 'Monkfish - Fresh', 56.83);
  8. insert into product (id, product_name, price_per_unit) values (3, 'Irish Cream - Baileys', 95.24);
  9. insert into product (id, product_name, price_per_unit) values (4, 'Mussels - Frozen', 49.32);
  10. insert into product (id, product_name, price_per_unit) values (5, 'Shrimp - 16/20, Iqf, Shell On', 31.16);
  11. insert into product (id, product_name, price_per_unit) values (6, 'Chicken - Breast, 5 - 7 Oz', 65.55);
  12. insert into product (id, product_name, price_per_unit) values (7, 'Potatoes - Yukon Gold, 80 Ct', 23.18);
  13. insert into product (id, product_name, price_per_unit) values (8, 'Juice - Orange, Concentrate', 17.26);
  14. insert into product (id, product_name, price_per_unit) values (9, 'Wine - Prosecco Valdobienne', 12.49);
  15. insert into product (id, product_name, price_per_unit) values (10, 'Lemon Balm - Fresh', 33.51);
  16. insert into product (id, product_name, price_per_unit) values (11, 'Dr. Pepper - 355ml', 28.01);
  17. insert into product (id, product_name, price_per_unit) values (12, 'Sole - Fillet', 49.85);
  18. insert into product (id, product_name, price_per_unit) values (13, 'Chevere Logs', 61.47);
  19. insert into product (id, product_name, price_per_unit) values (14, 'Carbonated Water - Orange', 42.93);
  20. insert into product (id, product_name, price_per_unit) values (15, 'Bread - Sticks, Thin, Plain', 20.57);
  21. insert into product (id, product_name, price_per_unit) values (16, 'Straw - Regular', 65.74);
  22. insert into product (id, product_name, price_per_unit) values (17, 'Jameson Irish Whiskey', 64.74);
  23. insert into product (id, product_name, price_per_unit) values (18, 'Chef Hat 25cm', 8.58);
  24. insert into product (id, product_name, price_per_unit) values (19, 'Pastry - Choclate Baked', 85.45);
  25. insert into product (id, product_name, price_per_unit) values (20, 'Vinegar - White', 61.2);
  26. insert into product (id, product_name, price_per_unit) values (21, 'Crush - Orange, 355ml', 2.13);
  27. insert into product (id, product_name, price_per_unit) values (22, 'Soup - Campbells Beef Stew', 15.54);
  28. insert into product (id, product_name, price_per_unit) values (23, 'Smoked Tongue', 37.86);
  29. insert into product (id, product_name, price_per_unit) values (24, 'Aspic - Amber', 33.91);
  30. insert into product (id, product_name, price_per_unit) values (25, 'Huck White Towels', 23.29);
  31. insert into product (id, product_name, price_per_unit) values (26, 'Tea - Black Currant', 85.92);
  32. insert into product (id, product_name, price_per_unit) values (27, 'Milk Powder', 62.24);
  33. insert into product (id, product_name, price_per_unit) values (28, 'Stock - Veal, Brown', 37.36);
  34. insert into product (id, product_name, price_per_unit) values (29, 'Cranberries - Dry', 17.05);
  35. insert into product (id, product_name, price_per_unit) values (30, 'Rice Wine - Aji Mirin', 19.04);
  36. insert into product (id, product_name, price_per_unit) values (31, 'Tuna - Fresh', 93.49);
  37. insert into product (id, product_name, price_per_unit) values (32, 'Juice - Ocean Spray Kiwi', 81.42);
  38. insert into product (id, product_name, price_per_unit) values (33, 'Wine - Zonnebloem Pinotage', 42.68);
  39. insert into product (id, product_name, price_per_unit) values (34, 'Carroway Seed', 66.87);
  40. insert into product (id, product_name, price_per_unit) values (35, 'Bagel - Everything Presliced', 65.31);
  41. insert into product (id, product_name, price_per_unit) values (36, 'Ice Cream - Strawberry', 73.52);
  42. insert into product (id, product_name, price_per_unit) values (37, 'Soup V8 Roasted Red Pepper', 70.58);
  43. insert into product (id, product_name, price_per_unit) values (38, 'Ecolab - Hobart Washarm End Cap', 58.59);
  44. insert into product (id, product_name, price_per_unit) values (39, 'Gatorade - Cool Blue Raspberry', 19.36);
  45. insert into product (id, product_name, price_per_unit) values (40, 'Sprouts - Peppercress', 69.19);
  46. insert into product (id, product_name, price_per_unit) values (41, 'Wine - Domaine Boyar Royal', 81.42);
  47. insert into product (id, product_name, price_per_unit) values (42, 'Shrimp - Baby, Cold Water', 86.15);
  48. insert into product (id, product_name, price_per_unit) values (43, 'Island Oasis - Cappucino Mix', 47.62);
  49. insert into product (id, product_name, price_per_unit) values (44, 'Compound - Raspberry', 44.45);
  50. insert into product (id, product_name, price_per_unit) values (45, 'Shark - Loin', 73.39);
  51. insert into product (id, product_name, price_per_unit) values (46, 'Food Colouring - Pink', 14.15);
  52. insert into product (id, product_name, price_per_unit) values (47, 'Clam - Cherrystone', 73.37);
  53. insert into product (id, product_name, price_per_unit) values (48, 'Schnappes - Peach, Walkers', 74.49);
  54. insert into product (id, product_name, price_per_unit) values (49, 'Nantucket Apple Juice', 39.15);
  55. insert into product (id, product_name, price_per_unit) values (50, 'Pastry - Baked Scones - Mini', 13.41);
  56. insert into product (id, product_name, price_per_unit) values (51, 'Carbonated Water - Lemon Lime', 41.48);
  57. insert into product (id, product_name, price_per_unit) values (52, 'Wine - Cotes Du Rhone Parallele', 12.64);
  58. insert into product (id, product_name, price_per_unit) values (53, 'Lettuce - Mini Greens, Whole', 72.55);
  59. insert into product (id, product_name, price_per_unit) values (54, 'Artichoke - Bottom, Canned', 12.19);
  60. insert into product (id, product_name, price_per_unit) values (55, 'Muffin Mix - Blueberry', 30.65);
  61. insert into product (id, product_name, price_per_unit) values (56, 'Oysters - Smoked', 38.92);
  62. insert into product (id, product_name, price_per_unit) values (57, 'Mahi Mahi', 1.59);
  63. insert into product (id, product_name, price_per_unit) values (58, 'Temperature Recording Station', 5.69);
  64. insert into product (id, product_name, price_per_unit) values (59, 'Soup Campbells Split Pea And Ham', 31.02);
  65. insert into product (id, product_name, price_per_unit) values (60, 'Ecolab - Medallion', 89.54);
  66. insert into product (id, product_name, price_per_unit) values (61, 'Red Currants', 85.66);
  67. insert into product (id, product_name, price_per_unit) values (62, 'Cheese - Brie, Cups 125g', 6.41);
  68. insert into product (id, product_name, price_per_unit) values (63, 'Devonshire Cream', 57.31);
  69. insert into product (id, product_name, price_per_unit) values (64, 'Scallop - St. Jaques', 85.71);
  70. insert into product (id, product_name, price_per_unit) values (65, 'Bar Energy Chocchip', 90.22);
  71. insert into product (id, product_name, price_per_unit) values (66, 'Turnip - White, Organic', 21.94);
  72. insert into product (id, product_name, price_per_unit) values (67, 'Wine - White, Gewurtzraminer', 98.87);
  73. insert into product (id, product_name, price_per_unit) values (68, 'Tray - Foam, Square 4 - S', 34.25);
  74. insert into product (id, product_name, price_per_unit) values (69, 'Fennel', 34.99);
  75. insert into product (id, product_name, price_per_unit) values (70, 'Yogurt - French Vanilla', 86.18);
  76. insert into product (id, product_name, price_per_unit) values (71, 'Artichoke - Fresh', 72.33);
  77. insert into product (id, product_name, price_per_unit) values (72, 'Beer - Sleemans Honey Brown', 30.82);
  78. insert into product (id, product_name, price_per_unit) values (73, 'Muffin - Mix - Creme Brule 15l', 74.82);
  79. insert into product (id, product_name, price_per_unit) values (74, 'Scrubbie - Scotchbrite Hand Pad', 52.73);
  80. insert into product (id, product_name, price_per_unit) values (75, 'Wine - Red Oakridge Merlot', 66.06);
  81. insert into product (id, product_name, price_per_unit) values (76, 'Pastry - Key Limepoppy Seed Tea', 81.45);
  82. insert into product (id, product_name, price_per_unit) values (77, 'Marsala - Sperone, Fine, D.o.c.', 56.48);
  83. insert into product (id, product_name, price_per_unit) values (78, 'Bread - Dark Rye, Loaf', 11.17);
  84. insert into product (id, product_name, price_per_unit) values (79, 'Cheese - Victor Et Berthold', 81.79);
  85. insert into product (id, product_name, price_per_unit) values (80, 'Pea - Snow', 20.96);
  86. insert into product (id, product_name, price_per_unit) values (81, 'Veal - Insides, Grains', 30.51);
  87. insert into product (id, product_name, price_per_unit) values (82, 'Clam Nectar', 7.73);
  88. insert into product (id, product_name, price_per_unit) values (83, 'Creme De Menthe Green', 20.88);
  89. insert into product (id, product_name, price_per_unit) values (84, 'Propel Sport Drink', 78.59);
  90. insert into product (id, product_name, price_per_unit) values (85, 'Muffin - Mix - Bran And Maple 15l', 38.34);
  91. insert into product (id, product_name, price_per_unit) values (86, 'Sobe - Berry Energy', 3.81);
  92. insert into product (id, product_name, price_per_unit) values (87, 'Raspberries - Fresh', 49.1);
  93. insert into product (id, product_name, price_per_unit) values (88, 'Chips - Potato Jalapeno', 27.89);
  94. insert into product (id, product_name, price_per_unit) values (89, 'Nut - Almond, Blanched, Sliced', 1.96);
  95. insert into product (id, product_name, price_per_unit) values (90, 'Cranberries - Dry', 9.04);
  96. insert into product (id, product_name, price_per_unit) values (91, 'Artichokes - Jerusalem', 58.71);
  97. insert into product (id, product_name, price_per_unit) values (92, 'Raspberries - Fresh', 67.0);
  98. insert into product (id, product_name, price_per_unit) values (93, 'Beef - Baby, Liver', 69.04);
  99. insert into product (id, product_name, price_per_unit) values (94, 'Lotus Rootlets - Canned', 84.4);
  100. insert into product (id, product_name, price_per_unit) values (95, 'Maple Syrup', 55.65);
  101. insert into product (id, product_name, price_per_unit) values (96, 'Pears - Bosc', 32.34);
  102. insert into product (id, product_name, price_per_unit) values (97, 'Amarula Cream', 56.09);
  103. insert into product (id, product_name, price_per_unit) values (98, 'Sage Ground Wiberg', 63.83);
  104. insert into product (id, product_name, price_per_unit) values (99, 'Wine - Prosecco Valdobiaddene', 67.68);
  105. insert into product (id, product_name, price_per_unit) values (100, 'Wine - White, Gewurtzraminer', 55.29);
  106.  
  107.  
  108. create table wishlist (
  109.     wish_list_id INT PRIMARY KEY,
  110.     first_name VARCHAR(50),
  111.     last_name VARCHAR(50),
  112.     email VARCHAR(50),
  113.     price_range INT
  114. );
  115. insert into wishlist (wish_list_id, first_name, last_name, email, price_range) values (1, 'Riannon', 'Nuzzetti', 'rnuzzetti0@wp.com', 82);
  116. insert into wishlist (wish_list_id, first_name, last_name, email, price_range) values (2, 'Caresse', 'Onyon', 'conyon1@reddit.com', 75);
  117. insert into wishlist (wish_list_id, first_name, last_name, email, price_range) values (3, 'Lexi', 'Fyndon', 'lfyndon2@google.com.au', 95);
  118. insert into wishlist (wish_list_id, first_name, last_name, email, price_range) values (4, 'Cybil', 'Rycraft', 'crycraft3@oaic.gov.au', 21);
  119. insert into wishlist (wish_list_id, first_name, last_name, email, price_range) values (5, 'Cherry', 'Greir', 'cgreir4@boston.com', 46);
  120. insert into wishlist (wish_list_id, first_name, last_name, email, price_range) values (6, 'Stephannie', 'Ringer', 'sringer5@arizona.edu', 26);
  121. insert into wishlist (wish_list_id, first_name, last_name, email, price_range) values (7, 'Trixi', 'Tatlow', 'ttatlow6@scientificamerican.com', 25);
  122. insert into wishlist (wish_list_id, first_name, last_name, email, price_range) values (8, 'Matilda', 'MacTrustey', 'mmactrustey7@jigsy.com', 53);
  123. insert into wishlist (wish_list_id, first_name, last_name, email, price_range) values (9, 'Evaleen', 'Squire', 'esquire8@last.fm', 20);
  124. insert into wishlist (wish_list_id, first_name, last_name, email, price_range) values (10, 'Noell', 'Purselowe', 'npurselowe9@blogger.com', 72);
  125. insert into wishlist (wish_list_id, first_name, last_name, email, price_range) values (11, 'Jesse', 'Courteney', 'jcourteneya@timesonline.co.uk', 16);
  126. insert into wishlist (wish_list_id, first_name, last_name, email, price_range) values (12, 'Linn', 'Danzig', 'ldanzigb@unicef.org', 28);
  127. insert into wishlist (wish_list_id, first_name, last_name, email, price_range) values (13, 'Joyce', 'Gerhardt', 'jgerhardtc@omniture.com', 62);
  128. insert into wishlist (wish_list_id, first_name, last_name, email, price_range) values (14, 'Simonne', 'Maddrah', 'smaddrahd@wufoo.com', 53);
  129. insert into wishlist (wish_list_id, first_name, last_name, email, price_range) values (15, 'Andonis', 'Addams', 'aaddamse@nba.com', 95);
  130.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement