Displaying 2 results from an estimated 2 matches for "jesakos".
2010 Apr 28
0
Error loading RMySQL
...DB. In actuality, I have a perl script
that does an initial preparation of the data, and then invokes the R script
- all of which work fine).
The very last five lines of my script are:
print(resultsdataframe);
library(RMySQL);
con <-
dbConnect(MySQL(),user="rejbyers",password="jesakos",dbname="merchants2");
dbWriteTable(con,"results",resultsdataframe);
dbDisconnect(con);
The print statement works fine, and shows me the results I expected. But
library(RMySQL) fails, which makes all the rest of the lines fail. The
command and error message is:
> li...
2008 Oct 08
0
Applying an R script to data within MySQL? How to?
...MySQL and retrieve data using RMySQL as
follows:
> library(DBI)
> library(RMySQL)
> MySQL(max.con = 16, fetch.default.rec = 500, force.reload = F)
<MySQLDriver:(3800)>
> m <- dbDriver("MySQL")
> con <- dbConnect(m, user="rejbyers", password = "jesakos",
> host="localhost", dbname = "merchants2")
> rs <- dbSendQuery(con, "select * from merchants")
> df <- fetch(rs, n = 150)
> df
And of course, that last statement is followed by the entire contents of
"merchants"
Now, I have a script...