Changes between Version 4 and Version 5 of CookBook RHT_UGA


Ignore:
Timestamp:
Oct 3, 2011 11:46:09 AM (14 years ago)
Author:
celine
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • CookBook RHT_UGA

    v4 v5  
    44 
    55{{{ 
     6#!sql 
    67drop table  if exists uga2010.id_drain; 
    78     CREATE TABLE uga2010.id_drain ( 
    … …  
    107108 
    108109{{{ 
     110#sql! 
    109111insert into uga2010.id_drain(gid,id_drain,uga) values ('3067','3224','RhoneMediterranee'),('11638','11467','RhoneMediterranee'),('22455','22419','RhoneMediterranee'),('24629','24470','Corse'),('26919','26772','Corse'),('71671','501772','Rhin');   -- 6 lignes 
    110112insert into uga2010.id_drain(gid,id_drain) values ('51479','301049'),('53501','303129'),('53521','303155'),('53471','303111'),('53481','303125'),('53531','303174'),('53571','303204'),('53695','303128'),('53710','303381'),('54108','303716'),('55321','304896'),('56267','305902'),('56268','305940'),('57509','307077'),('57623','307258'),('57860','307371'),('61605','311335'),('61606','311248'),('61639','311340'),('61759','311471'),('61766','311476'),('61767','311394'),('61885','311500'),('61904','311604'),('61922','311676'),('61924','311490'),('61925','311640'),('61939','311667'); 
    … …  
    116118#TODO voir pb doublons 
    117119{{{ 
     120#!sql 
    118121select count(id_drain), id_drain from uga2010.id_drain group by id_drain order by count(id_drain) 
    119122}}}