w5ZbD8sf

1drop table if exists ingrediant;
2
3create table ingrediant (
4  idIngrediant int auto_increment primary key,
5  name varchar(100) not null
6);
7
8drop table if exists recette;
9
10create table recette (
11  idRecette int auto_increment primary key,
12  name varchar(150)
13);
14
15drop table if exists utilise;
16
17create table utilise (
18  idRecette int,
19  idIngrediant int,
20  FOREIGN KEY (idRecette) REFERENCES recette(idRecette),
21  FOREIGN KEY (idIngrediant) REFERENCES ingrediant(idIngrediant)
22);
23
24insert into recette(name) values
25  ('Poule au pot à l ancienne'),
26  ('La teurgoule de Christophe Michalak')
27;
28
29insert into ingrediant(name) values
30  ('sel'),
31  ('vanille'),
32  ('riz'),
33  ('lait'),
34  ('Poivre'),
35  ('oignon'),
36  ('poireaux')
37;
38
39insert into utilise values
40  ('1','1'),
41  ('1','5'),
42  ('1','6'),
43  ('1','7'),
44  ('2','1'),
45  ('2','2'),
46  ('2','3')
47;
48
49describe recette;
50describe ingrediant;
51describe utilise;
52
53select * from recette r
54inner join
55utilise u
56inner join
57ingrediant i
58on r.idRecette = u.idRecette
59and i.idIngrediant = u.idIngrediant;