dbxInsert: Insert records

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

Description

Insert records

Usage

dbxInsert(conn, table, records, batch_size = NULL, returning = NULL)

Arguments

conn	A DBIConnection object
table	The table name to insert
records	A data frame of records to insert
batch_size	The number of records to insert in a single statement (defaults to all)
returning	Columns to return

Examples

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

records <- data.frame(temperature=c(32, 25))
dbxInsert(db, table, records)

dbx documentation built on Jan. 17, 2021, 9:06 a.m.