In perl DBI, there is a method for preparing sql commands with wildcards and then executing them with parameter bindings. Is there a way to do this within RMySQL? I would like to be able to look up values in a table based on a key supplied from R. Thanks, Sean
Hi! ?paste works fine for me. Sincerely Eryk *********** REPLY SEPARATOR *********** On 6/3/2004 at 9:32 AM Sean Davis wrote:>>>In perl DBI, there is a method for preparing sql commands with >>>wildcards and >>>then executing them with parameter bindings. Is there a way to do this >>>within RMySQL? I would like to be able to look up values in a table >>>based >>>on a key supplied from R. >>> >>>Thanks, >>>Sean >>> >>>______________________________________________ >>>R-help at stat.math.ethz.ch mailing list >>>https://www.stat.math.ethz.ch/mailman/listinfo/r-help >>>PLEASE do read the posting guide! http://www.R-project.org/posting-guide.htmlDipl. bio-chem. Eryk Witold Wolski @ MPI-Moleculare Genetic Ihnestrasse 63-73 14195 Berlin 'v' tel: 0049-30-83875219 / \ mail: wolski at molgen.mpg.de ---W-W---- http://www.molgen.mpg.de/~wolski
Prepared statements are not yet in the "production" 4.0 release of MySQL, only in the development or alpha version 4.1. I hope to add prepared statements and data.frame bindings by the time 4.1 becomes the "production" release. The API for working with prepared statements and bindings from R will be most likely very similar the current ROracle implementation. -- David Sean Davis wrote:> In perl DBI, there is a method for preparing sql commands with wildcards and > then executing them with parameter bindings. Is there a way to do this > within RMySQL? I would like to be able to look up values in a table based > on a key supplied from R. > > Thanks, > Sean > > ______________________________________________ > R-help at stat.math.ethz.ch mailing list > https://www.stat.math.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html