Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO test.products
- (ProductName, Price)
- VALUES
- ("Product A","99,99"),
- ("Product B","49,95"),
- ("Product C","5,95");
- INSERT INTO test.orders
- (Customer)
- VALUES
- ("Customer A"),
- ("Customer B"),
- ("Customer B");
- INSERT INTO test.products_per_order
- (Orders_idOrders, Products_idProducts, Price, Quantity)
- VALUES
- ("1","1",(Select Price from test.products),"5"),
- ("1","2",(Select Price from test.products),"4"),
- ("2","1",(Select Price from test.products),"10"),
- ("3","2",(Select Price from test.products),"3"),
- ("3","3",(Select Price from test.products),"9");
Add Comment
Please, Sign In to add comment