[R-sig-DB] RMySQL frustrations

[Sean Davis]

On Thu, May 17, 2012 at 10:59 AM, Mark Moon <mmoon using tensegritycapital.com>wrote:

> Getting frustrated using R with MySQL (on Debian Squeeze).  I can
> connect to mySQL database and I can execute simple queries.  But, having
> various difficulties executing queries with multiple statements
> separated by ";".  Set the client.flag to CLIENT_MULTI_STATEMENTS but
> still having difficulties.
>
> Questions: are the RMySQL and RODBC packages really meant just for
> simple, one line queries?


What kinds of queries are you trying to do that require multiple statements
separated by ";"?  It seems these could be simply separated into individual
queries without loss of generality?

Sean


> Can anyone point me to where I might learn
> how to execute more complicated queries with in R?
>
> Thanks!
>
> Mark
>
> _______________________________________________
> R-sig-DB mailing list -- R Special Interest Group
> R-sig-DB using r-project.org
> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>

	[[alternative HTML version deleted]]