Re: [R] connect to local mySQL database

2013-05-16 Thread Martin Batholdy
> Can you clarify: are you trying to connect to a mySQL database, or to a > sqlite database? It is a sqlite database. Thanks for pointing that out! Now it works just like in python ;). con <- dbConnect(SQLite(), dbname="xy.sqlite") res <- dbSendQuery(conn = con, "SELECT * FROM table1 WHERE x

Re: [R] connect to local mySQL database

2013-05-16 Thread Sarah Goslee
Hi Martin, Can you clarify: are you trying to connect to a mySQL database, or to a sqlite database? They're not at all the same thing, and I can't tell from your question which you're after. You need either RMySQL, or if you actually want an sqlite database, RSQLite or sqldf. Sarah On Thursday,

[R] connect to local mySQL database

2013-05-16 Thread Martin Batholdy
Hi, I would like to access a local mysql database. In python using the sqlite3 library it is quite straightforward. I just have to pass the path to the sqlite-file; sqlite3.connect('.../xy.sqlite') Is there something similar in R (or specifically in the RMySQL package)? It seems like I have t