Advertisement
Guest User

such_final_sql_stuff

a guest
Oct 1st, 2017
419
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. INSERT INTO auction VALUES
  2. (1, 'A well used fridge from 1989. I originally inherited it from my grandparents back in 2009. After carrying it all the way from my basement, my palms were sweaty, knees weak, arms were heavy, theres vomit on the sweater already.', 200, 'Old fridge', 1506529563918, 1457, NULL);
  3.  
  4. INSERT INTO auction VALUES
  5. (2, 'Almost unused sneakers, selling because my dad never uses them', 250, 'Sneakers', 1506555563918, 1460, NULL);
  6.  
  7. INSERT INTO auction VALUES
  8. (3, ‘Dishwasher FROM Electrolux. Used FOR 1 YEAR, NEW price $2200
  9.  ', 1200, 'Dishwasher', 1506652263918, 1457, null);
  10.  
  11. insert into category (id, img_url, name) values (1457,'https://i.imgur.com/p3fWg61.png' ,'Electronics');
  12. insert into category (id, img_url, name) values (1458,'https://i.imgur.com/V1OcIe1.png', 'Household');
  13. insert into category (id, img_url, name) values (1459,'https://i.imgur.com/1xOJPL8.png', 'Travel');
  14. insert into category (id, img_url, name) values (1460,'https://i.imgur.com/u2SfD99.png', 'Mechanics');
  15. insert into category (id, img_url, name) values (1461,'https://i.imgur.com/mW4VmV9.png','Fashion');
  16. insert into category (id, img_url, name) values (1462,'https://i.imgur.com/tmRBbKN.png', 'Other');
  17.  
  18. insert into bid (id, amount, auction_id) values (6541, 230, 1);
  19. insert into bid (id, amount, auction_id) values (6542, 210, 1);
  20. insert into bid (id, amount, auction_id) values (6543, 275, 2);
  21. insert into bid (id, amount, auction_id) values (6544, 265, 2);
  22.  
  23. update auction set bid_id = 6541 where id = 1;
  24. update auction set bid_id = 6543 where id = 2;
  25.  
  26. insert into seller values (9871, 'Daleveien 102', 'Sporty_sportsmann@gmail.com', 'Sporty Sportsmann', 41234599, 10, '4325');
  27. INSERT INTO Sell value (9872, ' Skogveien 10 ', ' Test.testesen@gmail.com ', ' Test Testesen ', 40466599, 7, ' 4258 ');
  28. insert into seller values (9873, 'Tømmerveien 20', 'Jan.banan.heisekran@gmail.com', 'Jan B. Heisekran', 45410878, 5, '0105’);
  29.  
  30. INSERT INTO seller_auction VALUES (9871, 2);
  31. INSERT INTO seller_auction VALUES (9872, 1);
  32. INSERT INTO seller_auction VALUES (9873, 3);
  33.  
  34. UPDATE auction SET seller_id = 9871 WHERE id = 2;
  35. UPDATE auction SET seller_id = 9872 WHERE id = 1;
  36. UPDATE auction SET seller_id = 9873 WHERE id = 3;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement