[R-sig-DB] RMySQL frustrations

[Mark Moon]

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?  Can anyone point me to where I might learn 
how to execute more complicated queries with in R?

Thanks!

Mark