Here's my MYSQL setup for retrieving data:
library(RMySQL)
channel <- dbConnect(MySQL(), user="xxxxxx", password="xxxxxx",
dbname="HistData", host="nomnom.cvgrllc.com")
EDM1 = dbGetQuery(channel, paste("select Date, o, h, l, c, v, a from
HistBondData Where Symbol = 'EDM1' AND a != 0 ORDER BY Date ASC"))
Another poster posted something for ODBC which works well for MSSQL
servers (and could work for mysql, if you have a odbc dsn setup to work
with mysql)
HTH...
-c
David Lubbers wrote:
With good and faithful python remote database queries look something
like this:
url.urlopen("username/pssw...@host",query)
where query is something like "select * from table where ...."
Does R support queries on remote hosts with username and password?
What does a simple example look like?
Thank you.
______________________________________________
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.
______________________________________________
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.