Changes between Version 36 and Version 37 of Cookbook CCM21_UGA

Timestamp:

Sep 4, 2010 10:11:57 AM (15 years ago)

Author:

celine

Comment:

--

Cookbook CCM21_UGA

@@ -113 +113 @@
 INSERT INTO uga2010.wso (uga,wso_id) VALUES ('Loire','291111')
 INSERT INTO uga2010.wso (uga,wso_id) VALUES ('Rhin','291110')
-INSERT INTO uga2010.wso (uga,wso_id) VALUES ('Garonne','Garonne','Garonne','291125','291126','309731')
-
-
-
--- Réinsertion des wso_id supprimés (sans doublon)
-INSERT INTO uga2010.wso (wso_id) (select wso_id from uga2010.wso group by wso_id having count(wso_id)>1);
-
--- Pour chaque wso_id insertion de l'UGA correspondant
-UPDATE uga2010.wso
-SET uga='ArtoisPicardie'
-WHERE wso_id='291223';
-UPDATE uga2010.wso
-SET uga='Adour'
-WHERE wso_id='291194';
-UPDATE uga2010.wso
-SET uga='Meuse'
-WHERE wso_id='291130';
-UPDATE uga2010.wso
-SET uga='Loire'
-WHERE wso_id='291111';
-UPDATE uga2010.wso
-SET uga='Rhin'
-WHERE wso_id='291110';
-UPDATE uga2010.wso
-SET uga='Garonne'
-WHERE wso_id in ('291125','291126','309731');
-UPDATE uga2010.wso
-SET uga='SeineNormandie'
-WHERE wso_id in ('291115','291249');
-UPDATE uga2010.wso
-SET uga='RhoneMediterranee'
-WHERE wso_id in ('291112','291513','292706','442353');
+INSERT INTO uga2010.wso (uga,wso_id) VALUES ('Garonne','291125'),('Garonne','291126'),('Garonne','309731')
+INSERT INTO uga2010.wso (uga,wso_id) VALUES ('SeineNormandie','291115'),('SeineNormandie','291249')
+INSERT INTO uga2010.wso (uga,wso_id) VALUES ('RhoneMediterranee','291112'),('RhoneMediterranee','291513'),('RhoneMediterranee','292706'),('RhoneMediterranee','442353')
 }}}
-
-INSERT INTO films SELECT * FROM tmp_films WHERE date_prod < '2004-05-07';
 
 '''J'ai un doute pour la requête entre wso_id et wso1_id  lequel choisir ??'''