Re ading from a Database
Some of the simpler commands could surely be done using SQL-only queries, but thats too simple for my project. I need to create some more complex commands that would only be possible using R. Indeed if anyone has any suggestions for this, Id also appreciate that. Every little bit of information I get helps me finish college:-) Thanks for that info Ben and thanks to anyone else who shares some much needed insight with me.
Ben Bolker wrote:
DonkeyRhubarb <michaeligoe <at> gmail.com> writes:
I'm quite new to R and have limited experience. What Im trying to do is very important as it is part of my final year project; or more so the central idea behind it. I will be creating BibTex files to enter into a mySQL database. I then need to perform operations on this DB like 'return studies similar to x'. It's really just getting a start at this that I'm having trouble with and if anyone could offer any advice whatsoever I would be more than grateful. Many thanks.
Hmmm. This sounds much more like a database question than
an R question. R has various interfaces (RmySQL, RODBC, etc)
for interfaces to relational databases. Section 4 of the
R data import/export manual gives quite a bit of detail.
I think that if you need more information on SQL queries etc.
you need to start with a local source (who is the advisor
for your project?)
good luck
Ben Bolker
______________________________________________ R-help at 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.
View this message in context: http://www.nabble.com/Reading-from-a-Database-tp22578072p22587990.html Sent from the R help mailing list archive at Nabble.com.