Changes between Version 13 and Version 14 of uga2010.wso1
- Timestamp:
- May 25, 2012 1:35:05 PM (13 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
uga2010.wso1
v13 v14 7 7 Création de la table uga2010.wso1 [[BR]] 8 8 {{{ 9 #!sql 9 10 drop table if exists uga2010.wso1; 10 11 CREATE TABLE uga2010.wso1 ( … … 109 110 110 111 {{{ 112 #!sql 111 113 DELETE FROM uga2010.wso1 where wso1_id in ('369830','360673'); 112 114 DELETE FROM uga2010.wso1 where wso1_id='340390' and uga='Meuse'; … … 170 172 Rapport ONEMA 171 173 {{{ 174 #!sql 172 175 select count(uga1), uga1 from uga2010.ugawso1 group by uga1 order by uga1; 173 176 select sum(shape_leng)/1000, uga1 from uga2010.ugawso1 group by uga1 order by uga1;