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
On 18/07/2009 3:04 PM, 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?
That depends on the database, not R. I have done remote database
calls using MySQL from R.
On Sat, Jul 18, 2009 at 3:04 PM, David Lubberslu...@comcast.net wrote:
With good and faithful python remote database queries look something
like this:
url.urlopen(username/pssw...@host,query)
where
Here's my MYSQL setup for retrieving data:
library(RMySQL)
channel - dbConnect(MySQL(), user=xx, password=xx,
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))
4 matches
Mail list logo