Import Data from SQL server into R using RMySQL

Click "Show More" To See Code.

*Note YouTube does not allow assignment operators, therefore I have used an equal sign below. Please replace with assignment operator in your code.

install.packages("RMySQL")
library(DBI)
connection = dbConnect(RMySQL::MySQL(),
dbname ="tweater",
host ="courses.csrrinzqubik.us-east-1.rds.amazonaws.com",
port = 3306,
user = "student",
password = "datacamp")
dbListTables(connection)
users = dbReadTable(connection, "users")
print(users)
dbGetQuery(connection, "select name from users")

Import Data from SQL server into R using RMySQL #data #SQL #R #datanalysis #importingdata