Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO Architecte VALUES
- (1, 'Pedro', 'Pedro', 'Architest', 'Rue des potiers', '12/03/1987', 0 );
- INSERT INTO Client VALUES
- (1, 'Pedro', 'Pedro', 'Rue des potiers' );
- INSERT INTO Artisan VALUES
- (1, 'Delatruelle', 'Rue des potiers', 'Menuisier');
- INSERT INTO Artisan VALUES
- (2, 'Delatruelle2', 'Rue des potiers', 'Charpentier');
- INSERT INTO Projet VALUES
- (1,'PROJET INCROYABLE', 0, 'Négociation', 1, 1);
- INSERT INTO Chantier VALUES
- (1, 1, 2000, '02/03/2018', '02/07/2018');
- INSERT INTO Chantier VALUES
- (1, 2, 6000, '02/03/2018', '02/07/2018');
- UPDATE Projet SET etat = 'terminé' WHERE idProjet = 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement