On Tue, Jan 26, 2010 at 11:55 AM, Seth Falcon <s...@userprimary.net> wrote: > > That sqldf only works if RMySQL is not attached seems like something worth > investigating and fixing. It should be possible to avoid such conflicts by > proper use of name spaces, but I have not looked into the details of what's > going on. >
It does work without RMySQL and in fact that is the normal way it is used since MySQL support has not been tested and you are really on your own if you want to try sqldf with MySQL (as indicated in documentation and home page). The driver= argument of the sqldf function call determines which database is used. If you don't specify the driver= argument then it uses the global option "sqldf.driver" to determine which database to use. If you have not set that either then it checks if RMySQL is attached and uses the MySQL database if it is and uses the SQLite database otherwise. ______________________________________________ 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.
