dbINSERT: Insert Single Record into an SQL Table

In renozao/dbutils: Database Utility Functions

Description

Insert Single Record into an SQL Table

Usage

dbINSERT(con, ..., .table, .verbose = FALSE)

Arguments

con	SQL database connection object
...	named arguments used as pairs (field, value)
.table	name of the table into which the recored is inserted
.verbose	verbose level

Value

the primary key of the newly inserted record

Examples

# connect to sample database
con <- .dbSampleConnection()
dbGetQuery(con, 'SELECT * FROM test')

# insert single record
id <- dbINSERT(con, a = 1, b = 'blabla', c = NA, t = sql_NOW, .table = 'test')
id

# query table again
dbGetQuery(con, 'SELECT * FROM test')

# clean up
dbEMPTY(con, 'test')

renozao/dbutils documentation built on May 27, 2019, 5:53 a.m.