Mulai sekarangMulai gratis

Establish a connection

The first step to import data from a SQL database is creating a connection to it. As Filip explained, you need different packages depending on the database you want to connect to. All of these packages do this in a uniform way, as specified in the DBI package.

dbConnect()creates a connection between your R session and a SQL database. The first argument has to be a DBIdriver object, that specifies how connections are made and how data is mapped between R and the database. Specifically for MySQL databases, you can build such a driver with RMySQL::MySQL().

If the MySQL database is a remote database hosted on a server, you'll also have to specify the following arguments in dbConnect(): dbname, host, port, user and password. Most of these details have already been provided.

Latihan ini merupakan bagian dari kursus

Intermediate Importing Data in R

Lihat Kursus

Instruksi latihan

  • Load the DBI library, which is already installed on DataCamp's servers.
  • Edit the dbConnect() call to connect to the MySQL database. Change the port argument (3306) and user argument ("student").

Latihan interaktif langsung praktik

Cobalah latihan ini dengan melengkapi kode contoh ini.

# Load the DBI package


# Edit dbConnect() call
con <- dbConnect(RMySQL::MySQL(), 
                 dbname = "tweater", 
                 host = "courses.csrrinzqubik.us-east-1.rds.amazonaws.com", 
                 port = 0000,
                 user = "",
                 password = "datacamp")
Edit dan Jalankan Kode