Changes between Version 30 and Version 31 of Cookbook CCM21_UGA

Timestamp:

Aug 30, 2010 4:03:33 PM (15 years ago)

Author:

celine

Comment:

--

Cookbook CCM21_UGA

@@ -104 +104 @@
 }}}
 
+Suppression des lignes de doublons
+{{{
+delete from uga2010.wso where wso_id not in (select wso_id from uga2010.wso group by wso_id having count(wso_id)>1) order by wso_id;
+INSERT INTO uga2010.wso (wso_id) (select wso_id from uga2010.wso group by wso_id having count(wso_id)>1);
+INSERT INTO uga2010.wso (uga) VALUES ('RhoneMediterranee') where wso_id  ;
+}}}
+
+
+
 '''J'ai un doute pour la requête entre wso_id et wso1_id  lequel choisir ??''' 
 ["Requete uga wso1_id"]