Skip to content

Instantly share code, notes, and snippets.

@jessedearing

jessedearing/MySQL.R

Created March 26, 2016 05:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jessedearing/fb72f8f87b364a697025 to your computer and use it in GitHub Desktop.
Save jessedearing/fb72f8f87b364a697025 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
MySQL.R
# Install
install.packages("RMySQL")
# Load MySQL
library(RMySQL)
#Connect
con <- dbConnect(MySQL(), dbname="thedb", host="mysqldb")
#Query
result <- dbGetQuery(con, "select * from a_table")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment