INSERT Queries

[Fiesepille]

`INSERT INTO Cocktail (cock_Id, name, picture, alcoholic, instructions, category, glass, rating) VALUES (1, 'Gin Tonic', null, true, '1. mach dies; 2. mach das', 'Longdrink', 'Gin glass', 3.5); INSERT INTO Cocktail (cock_Id, name, picture, alcoholic, instructions, category, glass, rating) VALUES (2, 'Sex On The Beach', null, true, '1. mach dies; 2. mach das', 'Frauendrink', 'Cock glass', 5.0); INSERT INTO Cocktail (cock_Id, name, picture, alcoholic, instructions, category, glass, rating) VALUES (3, 'anotherCock', null, true, '1. mach dies; 2. mach das', 'Longdrink', 'Gin glass', 2.0);

INSERT INTO INGREDIENT (Ingredient, Oz, Cocktail_cock_id) VALUES ('Gin', 2, 1); INSERT INTO INGREDIENT (Ingredient, Oz, Cocktail_cock_id) VALUES ('Tonic Water', 2, 1);

INSERT INTO INGREDIENT (Ingredient, Oz, Cocktail_cock_id) VALUES ('Sex', 3, 2); INSERT INTO INGREDIENT (Ingredient, Oz, Cocktail_cock_id) VALUES ('Sand', 1, 2); INSERT INTO INGREDIENT (Ingredient, Oz, Cocktail_cock_id) VALUES ('Whiskey', 0.5, 2);

INSERT INTO INGREDIENT (Ingredient, Oz, Cocktail_cock_id) VALUES ('Water', 5, 3); INSERT INTO INGREDIENT (Ingredient, Oz, Cocktail_cock_id) VALUES ('Vodka', 1, 3);`