dbExecute {DBI} | R Documentation |
Executes a statement and returns the number of rows affected.
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()
.
dbExecute(conn, statement, ...)
conn |
A DBIConnection object, as returned by
|
statement |
a character string containing SQL. |
... |
Other parameters passed on to methods. |
You can also use dbExecute()
to call a stored procedure
that performs data manipulation or other actions that do not return a result set.
To execute a stored procedure that returns a result set use dbGetQuery()
instead.
dbExecute()
always returns a
scalar
numeric
that specifies the number of rows affected
by the statement.
An error is raised when issuing a statement over a closed
or invalid connection,
if the syntax of the statement is invalid,
or if the statement is not a non-NA
string.
Subclasses should override this method only if they provide some sort of performance optimization.
The following argument is not part of the dbExecute()
generic
(to improve compatibility across backends)
but is part of the DBI specification:
params
(default: NULL
)
It must be provided as named arguments. See the "Specification" sections for details on its usage.
The param
argument allows passing query parameters, see dbBind()
for details.
For queries: dbSendQuery()
and dbGetQuery()
.
Other DBIConnection generics: DBIConnection-class
,
dbAppendTable
, dbCreateTable
,
dbDataType
, dbDisconnect
,
dbExistsTable
,
dbGetException
, dbGetInfo
,
dbGetQuery
, dbIsReadOnly
,
dbIsValid
, dbListFields
,
dbListObjects
, dbListResults
,
dbListTables
, dbReadTable
,
dbRemoveTable
, dbSendQuery
,
dbSendStatement
, dbWriteTable
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 # Pass values using the param argument: dbExecute( con, "INSERT INTO cars (speed, dist) VALUES (?, ?)", param = list(4:7, 5:8) ) dbReadTable(con, "cars") # there are now 10 rows dbDisconnect(con)