1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| INSERT INTO PIECE (PieceId, PieceNom) VALUES (1, 'aile') ;
INSERT INTO PIECE (PieceId, PieceNom) VALUES (2, 'train') ;
INSERT INTO PIECE (PieceId, PieceNom) VALUES (3, 'longeron') ;
INSERT INTO PIECE (PieceId, PieceNom) VALUES (4, 'aileron') ;
INSERT INTO PIECE (PieceId, PieceNom) VALUES (5, 'charnière') ;
INSERT INTO PIECE (PieceId, PieceNom) VALUES (6, 'rivet') ;
SELECT '' AS 'PIECE', * FROM PIECE ;
INSERT INTO COMPOSITION (ComposeId, ComposantId, Quantite) VALUES (1, 2, 1) ;
INSERT INTO COMPOSITION (ComposeId, ComposantId, Quantite) VALUES (1, 3, 5) ;
INSERT INTO COMPOSITION (ComposeId, ComposantId, Quantite) VALUES (1, 4, 1) ;
INSERT INTO COMPOSITION (ComposeId, ComposantId, Quantite) VALUES (1, 6, 100) ;
INSERT INTO COMPOSITION (ComposeId, ComposantId, Quantite) VALUES (2, 5, 3) ;
INSERT INTO COMPOSITION (ComposeId, ComposantId, Quantite) VALUES (2, 6, 8) ;
INSERT INTO COMPOSITION (ComposeId, ComposantId, Quantite) VALUES (3, 6, 10) ;
INSERT INTO COMPOSITION (ComposeId, ComposantId, Quantite) VALUES (4, 5, 2) ;
INSERT INTO COMPOSITION (ComposeId, ComposantId, Quantite) VALUES (4, 6, 5) ;
INSERT INTO COMPOSITION (ComposeId, ComposantId, Quantite) VALUES (5, 6, 4) ;
SELECT '' AS 'COMPOSITION', * FROM COMPOSITION ; |
Partager