Import Data from SQL server into R using RMySQL

Published: 11 September 2021
on channel: Joys of Data

1,117

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

On this page of the site you can watch the video online Import Data from SQL server into R using RMySQL with a duration of hours minute second in good quality, which was uploaded by the user Joys of Data 11 September 2021, share the link with friends and acquaintances, this video has already been watched 1,117 times on youtube and it was liked by 18 viewers. Enjoy your viewing!

618