MySQLTable_Connection

Creating a connection to MySQL

library(RMySQL)

## Warning: package 'RMySQL' was built under R version 3.3.3

## Loading required package: DBI

mydb = dbConnect(MySQL(), user='femi', password='data607', dbname='university', host='localhost')

To List attributes in MySQL movie table

dbListFields(mydb, 'movie')

## [1] "Movie"   "Name"    "Ratings"

To retreive data from Movie table in MySQL workbench

Movie_data <- dbSendQuery(mydb, "select * from movie")
data <- fetch(Movie_data)

dataframe of the movie table

data

##                Movie    Name Ratings
## 1             Thelma     Ben       4
## 2              Taken SHIRLEY       5
## 3      ATOMIC bLONDE    John       2
## 4              Lucky    Luke       3
## 5 The Lost City of Z   Aaron       3
## 6            Phantom  Nicole       1