Changes between Version 15 and Version 16 of Cookbook CCM21_Europe

Timestamp:

Feb 28, 2011 2:30:33 PM (14 years ago)

Author:

celine

Comment:

--

Cookbook CCM21_Europe

@@ -162 +162 @@
 select * from rbd_f1v3.bassin_pose b right join europe.wso w on b.wso_id=w.wso_id where emu='Anglian' and area='UK'
 }}}
+
+---6 wso_id qui doivent être rajouté dans europe.wso pour l'Elbe
+{{{
+select * from rbd_f1v3.bassin_pose b right join europe.wso w on b.wso_id=w.wso_id where emu='Elbe'
+}}}
+{{{
+insert into europe.wso(wso_id) values ('383'),('2005'),('8639'),('38619'),('38481'),('2020');
+UPDATE europe.wso set area='Elbe' where area IS NULL;
+}}}