Dear R users,
Basically, I desire to extract more than 1 column from a table in MySQL
database.
However, I get a pop-up error reading *"R for Windows GUI front-end has
encountered a problem and needs to close. We are sorry for the
incovenience."* when there are more than 1 field following "SELECT" phrase
in the "dbSendQuery" function.
Scripts below was used,
*library(DBI)
library(RMySQL)*
* *
*con <- dbConnect(MySQL(), user="XXX", password="XXX", dbname="XXX",
host="XXX")*
* *
*foo <- dbSendQuery(con, "SELECT pol, claims FROM GI.marine ORDER BY pol"
) *
*GI <- fetch(foo,n = -1)*
When I specify only 1 field (i.e *foo <- dbSendQuery(con, "SELECT pol
FROM GI.marine
ORDER BY pol"* ), it gives the desired query result without any error.
Your advise on resolving this issue would be highly appreciated.
Steven
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
