Hello,
I should first mention that I am not familiar with database management tools,
nor with database solutions for Mac OS X.
I currently have some data sitting on a MySQL Server version 5.0.51a-24+lenny4
I access through a web site using phpMyAdmin - 2.11.5.1. That is, the database
is sitting remotely and I have to access the table containing the data several
times during each day.
How can I read this data into a R data.frame without having to use phpMyAdmin
to download a csv file to my machine and then import it from there? Is there
some SQL query I can run directly from R into MySQL?
I have been looking at RMySQL, am I on the right track? Or should I be looking
at something else?
Thanks,
Luca
Mr. Luca Meyer
www.lucameyer.com
IBM SPSS Statistics release 19.0.0
R version 2.12.1 (2010-12-16)
Mac OS X 10.6.6 (10J567) - kernel Darwin 10.6.0
[[alternative HTML version deleted]]
_______________________________________________
R-SIG-Mac mailing list
R-SIG-Mac@r-project.org
https://stat.ethz.ch/mailman/listinfo/r-sig-mac
