Changes between Version 32 and Version 33 of Cookbook CCM21_UGA


Ignore:
Timestamp:
Aug 30, 2010 4:43:53 PM (15 years ago)
Author:
celine
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • TabularUnified Cookbook CCM21_UGA

    v32 v33  
    107107{{{ 
    108108delete 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) 
    109110INSERT 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 
    110112UPDATE uga2010.wso 
    111113SET uga='ArtoisPicardie'