Import table data

Intermediate Importing Data in R

Filip Schouwenaars

Instructor, DataCamp

con

con <- dbConnect(RMySQL::MySQL(),
         dbname = "company",
         host = "courses.csrrinzqubik.us-
                          east-1.rds.amazonaws.com",
         port = 3306,
         user = "student",
         password = "datacamp")

List and import tables

dbListTables(con)

"employees" "products"  "sales"

dbReadTable(con, "employees")

  id    name  started_at
1  1     Tom  2009-05-17
2  4   Frank  2012-07-06
3  6   Julie  2013-01-01
4  7 Heather  2014-11-23
5  9    John  2015-05-12

dbDisconnect(con)

TRUE

con

Error: internal error in RS_DBI_getConnection:
corrupt connection handle

Let's practice!

Intermediate Importing Data in R