Learn R Programming

RSQLite (version 2.3.0)

datasetsDb: A sample sqlite database

Description

This database is bundled with the package, and contains all data frames in the datasets package.

Usage

datasetsDb()

Arguments

Examples

Run this code
library(DBI)
db <- RSQLite::datasetsDb()
dbListTables(db)

dbReadTable(db, "CO2")
dbGetQuery(db, "SELECT * FROM CO2 WHERE conc < 100")

dbDisconnect(db)

Run the code above in your browser using DataLab