Query a MySQL Database from R using RMySQL

December 15, 2011
By

(This article was first published on Getting Genetics Done, and kindly contributed to R-bloggers)

I use this all the time, and the setup is dead simple. Follow the code below to load the RMySQL package, connect to a database (here the UCSC genome browser's public MySQL instance), set up a function to make querying easier, and query the database to return results as a data frame.

Getting Genetics Done by Stephen Turner is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License.

To leave a comment for the author, please follow the link and comment on his blog: Getting Genetics Done.
R-bloggers.com offers daily e-mail updates about R news and tutorials on topics such as: visualization (ggplot2, Boxplots, maps, animation), programming (RStudio, Sweave, LaTeX, SQL, Eclipse, git, hadoop, Web Scraping) statistics (regression, PCA, time series,ecdf, trading) and more...

If you got this far, why not subscribe for updates from the site? Choose your flavor: e-mail, twitter, RSS, or facebook...

Comments are closed.

Top 7 articles of the week

  1. Quandl Package - 5,000,000 free datasets at the tip of your fingers!
  2. Google Analytics + R = FUN!
  3. How R Grows
  4. AIC & BIC vs. Crossvalidation
  5. Select operations on R data frames
  6. Writing from R to Excel with xlsx
  7. SAS, SPSS, Stata Users: Learn R from Home June 17

Sponsors

Mango solutions
mango-solutions.com
Zero Inflated Models and Generalized Linear Mixed Models with R
Quantide: statistical consulting and training
RStudio homepage
RStudio: a free and open source IDE for R
REvolution analytics
HMS Analytical Software GmbH
http://www.eoda.de
Zero Inflated Models and Generalized Linear Mixed Models with R Zero Inflated Models and Generalized Linear Mixed Models with R. Zuur, Saveliev, Ieno (2012).