Changes between Version 30 and Version 31 of CookBook join ROE_RHT

Timestamp:

Nov 3, 2011 11:24:40 AM (13 years ago)

Author:

celine

Comment:

--

CookBook join ROE_RHT

@@ -216 +216 @@
 select id_drain, count(nbdams) as nbdams from rht.rht_bdcarthage_roev2 as r group by id_drain;
 
-alter table rht.rht_bdcarthage_roev2_nbdams add column c_height integer;
-alter table rht.rht_bdcarthage_roev2_nbdams add column c_score integer;
-update rht.rht_bdcarthage_roev2_nbdams set c_height=1;
-update rht.rht_bdcarthage_roev2_nbdams set c_score=1;
-}}}
+alter table rht.rht_bdcarthage_roev2_nbdams add column height integer;
+alter table rht.rht_bdcarthage_roev2_nbdams add column score integer;
+update rht.rht_bdcarthage_roev2_nbdams set height=1;
+update rht.rht_bdcarthage_roev2_nbdams set score=1;
+}}}