Changes between Version 31 and Version 32 of Cookbook CCM21_UGA


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

--

Legend:

Unmodified
Added
Removed
Modified

  • Cookbook CCM21_UGA

    v31 v32  
    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; 
    109109INSERT INTO uga2010.wso (wso_id) (select wso_id from uga2010.wso group by wso_id having count(wso_id)>1); 
    110 INSERT INTO uga2010.wso (uga) VALUES ('RhoneMediterranee') where wso_id  ; 
     110UPDATE uga2010.wso 
     111SET uga='ArtoisPicardie' 
     112WHERE wso_id='291223'; 
     113UPDATE uga2010.wso 
     114SET uga='Adour' 
     115WHERE wso_id='291194'; 
     116UPDATE uga2010.wso 
     117SET uga='Meuse' 
     118WHERE wso_id='291130'; 
     119UPDATE uga2010.wso 
     120SET uga='Loire' 
     121WHERE wso_id='291111'; 
     122UPDATE uga2010.wso 
     123SET uga='Rhin' 
     124WHERE wso_id='291110'; 
     125UPDATE uga2010.wso 
     126SET uga='Garonne' 
     127WHERE wso_id in ('291125','291126','309731'); 
     128UPDATE uga2010.wso 
     129SET uga='SeineNormandie' 
     130WHERE wso_id in ('291115','291249'); 
     131UPDATE uga2010.wso 
     132SET uga='RhoneMediterranee' 
     133WHERE wso_id in ('291112','291513','292706','442353'); 
    111134}}} 
    112135 
    113  
     136INSERT INTO films SELECT * FROM tmp_films WHERE date_prod < '2004-05-07'; 
    114137 
    115138'''J'ai un doute pour la requête entre wso_id et wso1_id  lequel choisir ??'''