Guest User

Untitled

a guest
Jan 22nd, 2019
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.56 KB | None | 0 0
  1. INSERT INTO test.products
  2. (ProductName, Price)
  3. VALUES
  4. ("Product A","99,99"),
  5. ("Product B","49,95"),
  6. ("Product C","5,95");
  7.  
  8. INSERT INTO test.orders
  9. (Customer)
  10. VALUES
  11. ("Customer A"),
  12. ("Customer B"),
  13. ("Customer B");
  14.  
  15. INSERT INTO test.products_per_order
  16. (Orders_idOrders, Products_idProducts, Price, Quantity)
  17. VALUES
  18. ("1","1",(Select Price from test.products),"5"),
  19. ("1","2",(Select Price from test.products),"4"),
  20. ("2","1",(Select Price from test.products),"10"),
  21. ("3","2",(Select Price from test.products),"3"),
  22. ("3","3",(Select Price from test.products),"9");
Add Comment
Please, Sign In to add comment