dbxSelect: Select records

In ankane/dbx: A Fast, Easy-to-Use Database Interface

Select records

Description

Select records

Usage

dbxSelect(conn, statement, params = NULL)

Arguments

conn	A DBIConnection object
statement	The SQL statement to use
params	Parameters to bind

Examples

db <- dbxConnect(adapter="sqlite", dbname=":memory:")
DBI::dbCreateTable(db, "forecasts", data.frame(id=1:3, temperature=20:22))

dbxSelect(db, "SELECT * FROM forecasts")

dbxSelect(db, "SELECT * FROM forecasts WHERE id = ?", params=list(1))

dbxSelect(db, "SELECT * FROM forecasts WHERE id IN (?)", params=list(1:3))

ankane/dbx documentation built on Dec. 12, 2023, 1:22 p.m.