dbExecute

0th

Percentile

Execute an update statement, query number of rows affected, and then close result set

dbExecute comes with a default implementation (which should work with most backends) that calls dbSendStatement, then dbGetRowsAffected, ensuring that the result is always free-d by dbClearResult.

Usage
dbExecute(conn, statement, ...)
Arguments
conn
A DBIConnection object, as produced by dbConnect.
statement
a character vector of length 1 containing SQL.
...
Other parameters passed on to methods.
Value

The number of rows affected by the statement

See Also

For queries: dbSendQuery and dbGetQuery.

Other DBIConnection generics: DBIConnection-class, dbDataType, dbDisconnect, dbExistsTable, dbGetException, dbGetInfo, dbGetQuery, dbIsValid, dbListFields, dbListResults, dbListTables, dbReadTable, dbRemoveTable, dbSendQuery, dbSendStatement

Aliases
  • dbExecute
Examples
library(DBI) con <- dbConnect(RSQLite::SQLite(), ":memory:") dbWriteTable(con, "cars", head(cars, 3)) dbReadTable(con, "cars") # there are 3 rows dbExecute(con, "INSERT INTO cars (speed, dist) VALUES (1, 1), (2, 2), (3, 3);") dbReadTable(con, "cars") # there are now 6 rows dbDisconnect(con)
Documentation reproduced from package DBI, version 0.5-1, License: LGPL (>= 2)

Community examples

Looks like there are no examples yet.