Calling the necessary packages
library(RMySQL)
## Loading required package: DBI
Establish MySQL connection
#establish connection to MySQL
dbinstance = dbConnect(MySQL(),user = "data607",password = "password",dbname = "data607", host = "localhost")
Fetch table from database
#Fetch table from database
movieratings = dbGetQuery(dbinstance,"select * from data607.peoplemovieratingsresults")
Look at table
movieratings
## FirstName LastName MovieTitle Rating
## 1 Spongebob Squarepants Green Room 4
## 2 Spongebob Squarepants 2001 Space Odyssey 4
## 3 Spongebob Squarepants Her 2
## 4 Spongebob Squarepants No Country For Old Men 5
## 5 Spongebob Squarepants Solo: A Star Wars Story 3
## 6 Spongebob Squarepants Spider-Man 3 5
## 7 Bojack Horseman Green Room 4
## 8 Bojack Horseman 2001 Space Odyssey 1
## 9 Bojack Horseman Her 2
## 10 Bojack Horseman No Country For Old Men 1
## 11 Bojack Horseman Solo: A Star Wars Story 2
## 12 Bojack Horseman Spider-Man 3 1
## 13 Mc Lovin Green Room 4
## 14 Mc Lovin 2001 Space Odyssey 3
## 15 Mc Lovin Her 3
## 16 Mc Lovin No Country For Old Men 2
## 17 Mc Lovin Solo: A Star Wars Story 3
## 18 Mc Lovin Spider-Man 3 3
## 19 Hank Hill Green Room 2
## 20 Hank Hill 2001 Space Odyssey 3
## 21 Hank Hill Her 3
## 22 Hank Hill No Country For Old Men 3
## 23 Hank Hill Solo: A Star Wars Story 3
## 24 Hank Hill Spider-Man 3 5
## 25 Jin Yang Green Room 4
## 26 Jin Yang 2001 Space Odyssey 1
## 27 Jin Yang Her 2
## 28 Jin Yang No Country For Old Men 5
## 29 Jin Yang Solo: A Star Wars Story 2
## 30 Jin Yang Spider-Man 3 2