Changes between Version 32 and Version 33 of Cookbook CCM21_UGA
- Timestamp:
- Aug 30, 2010 4:43:53 PM (15 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
TabularUnified Cookbook CCM21_UGA
v32 v33 107 107 {{{ 108 108 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; 109 -- Réinsertion des wso_id supprimés (sans doublon) 109 110 INSERT INTO uga2010.wso (wso_id) (select wso_id from uga2010.wso group by wso_id having count(wso_id)>1); 111 -- Pour chaque wso_id insertion de l'UGA correspondant 110 112 UPDATE uga2010.wso 111 113 SET uga='ArtoisPicardie'