R help - Jan 2008 - Just Beginning

Hi,

Im new to "R", I am currently doing a proect for college, in which
questions
are answered and the results are sent to a mySql database. Essentially I
want R to read from this database and generate graphs e.t.c. Dies anyone
know of a good website where I can learn the different commands needed to do
this? I have looked around on the net but cannot seem to find anything. Hope
to hear from someone soon.

Best Regards,

John.
-- 
View this message in context:
http://www.nabble.com/Just-Beginning-tp14665275p14665275.html
Sent from the R help mailing list archive at Nabble.com.

Dear John,

The first issue of R News had a very nice article by Brian Ripley on
accessing databases from R; you'll find it at
<http://cran.r-project.org/doc/Rnews/Rnews_2001-1.pdf>. There's also a
section on databases in the R Data Import/Export manual, which comes with R.
BTW, I don't generally think of this as a topic for beginners, but I suppose
that if you have experience with mySQL you'll find it relatively
straightforward.

I hope this helps,
 John

--------------------------------
John Fox, Professor
Department of Sociology
McMaster University
Hamilton, Ontario, Canada L8S 4M4
905-525-9140x23604
http://socserv.mcmaster.ca/jfox

> -----Original Message-----
> From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-
> project.org] On Behalf Of hoogeebear
> Sent: January-07-08 8:14 AM
> To: r-help at r-project.org
> Subject: [R] Just Beginning
> 
> 
> Hi,
> 
> Im new to "R", I am currently doing a proect for college, in
which
> questions
> are answered and the results are sent to a mySql database. Essentially
> I
> want R to read from this database and generate graphs e.t.c. Dies
> anyone
> know of a good website where I can learn the different commands needed
> to do
> this? I have looked around on the net but cannot seem to find anything.
> Hope
> to hear from someone soon.
> 
> Best Regards,
> 
> John.
> --
> View this message in context: http://www.nabble.com/Just-Beginning-
> tp14665275p14665275.html
> Sent from the R help mailing list archive at Nabble.com.
> 
> ______________________________________________
> 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.

R can talk to MySQL via the RMySQL and RODBC packages: which is easier
will depend on your infrastructure, including your OS.

You haven't even told us your OS.  But the 'R Data Import/Export
Manual'
and 'An Introduction to R', both of which ship with R, are the manuals
to
start with, as well as the package documentation.

On Mon, 7 Jan 2008, hoogeebear wrote:
>
> Hi,
>
> Im new to "R", I am currently doing a proect for college, in
which questions
> are answered and the results are sent to a mySql database. Essentially I
> want R to read from this database and generate graphs e.t.c. Dies anyone
> know of a good website where I can learn the different commands needed to
do
> this? I have looked around on the net but cannot seem to find anything.
Hope
> to hear from someone soon.
>
> Best Regards,
>
> John.
>
-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595