Query a MySQL Database from R using RMySQL
Year: 2011
Type: other
Abstract: 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 (CC BY) License.
DOI: 10.59350/cwqnk-mfm73
Author: Stephen Turner
Institution: University of Virginia
Language: English
Topic: Data Analysis with R
Subfield: Artificial Intelligence
Field: Computer Science
Domain: Physical Sciences
Open Access status: gold
OpenAlex ID: W4417085353