Hi all,
I'm trying to make the connection between R and MySQL. I set connection
parameters such as dbname, user, host in file .my.cnf
>library(DBI)
>library(RMySQL)
> drv <- dbDriver("MySQL")
> con <- dbConnect(drv)
Until here evrything's ok.
But there are lots of commands I found in R docs which are "not
found",
such as getTable. Deprecated (I successfully used dbListTables) or do I
simply miss a package ?
How should I use resultSets ? I am not able to close neither a
connection nor a ResultSet. I tried with close(con).
Thanks for any help.
Laurent