dbGetRowsAffected
From DBI v0.5-1
by Kirill Müller
The number of rows affected
This function returns the number of rows that were added, deleted, or updated by a data manipulation statement. For a selection query, this function returns 0.
Usage
dbGetRowsAffected(res, ...)
Arguments
- res
- An object inheriting from
DBIResult
. - ...
- Other arguments passed on to methods.
Value
-
a numeric vector of length 1
See Also
Other DBIResult generics: DBIResult-class
,
SQL
, dbBind
,
dbClearResult
, dbColumnInfo
,
dbFetch
, dbGetInfo
,
dbGetRowCount
,
dbGetStatement
,
dbHasCompleted
, dbIsValid
Examples
library(DBI)
con <- dbConnect(RSQLite::SQLite(), ":memory:")
dbWriteTable(con, "mtcars", mtcars)
rs <- dbSendStatement(con, "DELETE FROM mtcars")
dbGetRowsAffected(rs)
nrow(mtcars)
dbClearResult(rs)
dbDisconnect(con)
Community examples
Looks like there are no examples yet.