Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO STATION (nom_station,capacité,lieu,région,tarif)
- VALUES
- ('Venusa','350','Guadeloupe','Antilles','1200'),
- ('Farniente','200','Seychelles','Océan Indien','1500'),
- ('Santalba','150','Martinique','Antilles','2000'),
- ('Passac','400','Alpes','Europe','1000');
- INSERT INTO ACTIVITE (nom_station,libellé,prix)
- VALUES
- ('Venusa','Voile','150'),
- ('Venusa','Plongée','120'),
- ('Farniente','Plongée','130'),
- ('Passac','Ski','200'),
- ('Passac','Piscine','20'),
- ('Santalba','Kayac','50');
- INSERT INTO CLIENT (id_client, nom, prénom, ville, région, solde)
- VALUES
- ('10','Fogg','Phileas','Londres','Europe','12465'),
- ('20','Pascal','Blaise','Paris','Europe','6763'),
- ('30','Kerouac','Jack','New York','Amerique','9812');
- INSERT INTO SEJOUR (id_client, nom_station, début, nbplaces)
- VALUES
- ('10','Passac','1998/07/01','2'),
- ('30','Santalba','1996/08/14','5'),
- ('20','Santalba','1998/08/03','4'),
- ('30','Passac','1998/08/15','3'),
- ('30','Venusa','1998/08/03','3'),
- ('20','Venusa','1998/08/03','6'),
- ('30','Farniente','1999/06/24','5'),
- ('10','Farniente','1998/09/05','2');
Add Comment
Please, Sign In to add comment