Displaying 1 result from an estimated 1 matches for "region_areas".
Did you mean:
region_alias
2003 Apr 23
0
MySQL
...er a
> connection nor a ResultSet. I tried with close(con).
> Thanks for any help.
I used the following script:
library(RMySQL);
con <- dbConnect(dbDriver("MySQL"), dbname = "area");
regionarea <- dbGetQuery(con,
"select area from region_areas \
where region like \"Arctic Ocean\""
)$area;
mynn <- dbGetQuery(con,
paste("select year(date) as year,",
"avg(area1)/",regionarea,"*100 as area1,",...