MySQL and R Webinar
  • Home
  • Resources
  • MySQL
  • DBI
  • dplyr
  • Lahman DB

Resources

  • Using SQL:
    • Download and install MySQL
    • Download and install the MySQL Workbench. This is the officially-supported GUI for working with MyQL. It is free, open-source, and cross-platform.
    • dplyr provides a syntax for pulling MySQL data directly into R, but relies upon the RMySQL package to do so. This package is cross-platform, but is not always available as a binary.
    • Installing RMySQL:

      install.packages("RMySQL")

      If that doesn’t work, try:

      install.packages("RMySQL", type="source")
    • Read the MySQL Documentation!
  • Books
    • SQL in a Nutshell

Created by Ben Baumer.