Advertisement
Guest User

Untitled

a guest
Aug 30th, 2015
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1. INSERT INTO Buyer VALUES (1,'Myers','Mike');
  2. INSERT INTO Buyer VALUES (2,'Lopez','Jennifer');
  3. INSERT INTO Buyer VALUES (3,'Mathers','Marshall');
  4.  
  5. INSERT INTO Merchandise VALUES (3,'Microphone',1000);
  6. INSERT INTO Merchandise VALUES (2,'CD',50);
  7. INSERT INTO Merchandise VALUES (1,'Songtext',5000);
  8. INSERT INTO Merchandise VALUES (4,'Stuff',100);
  9.  
  10. INSERT INTO Orders VALUES(1,1,1990.10.31);
  11. INSERT INTO Orders VALUES(2,2,2005.11.20);
  12. INSERT INTO Orders VALUES(3,3,2010.06.30);
  13.  
  14. INSERT INTO OrderItem VALUES(1,1,2,5);
  15. INSERT INTO OrderItem VALUES(2,1,3,5);
  16. INSERT INTO OrderItem VALUES(3,1,1,15);
  17.  
  18. INSERT INTO OrderItem VALUES(4,2,1,50);
  19. INSERT INTO OrderItem VALUES(5,2,2,10);
  20. INSERT INTO OrderItem VALUES(6,2,4,18);
  21.  
  22. INSERT INTO OrderItem VALUES(7,3,1,0);
  23. INSERT INTO OrderItem VALUES(8,3,3,50);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement