dbExecute {DBI} | R Documentation |
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 |
statement |
a character vector of length 1 containing SQL. |
... |
Other parameters passed on to methods. |
The number of rows affected by the statement
For queries: dbSendQuery
and dbGetQuery
.
Other DBIConnection generics: DBIConnection-class
,
dbDataType
, dbDisconnect
,
dbExistsTable
,
dbGetException
, dbGetInfo
,
dbGetQuery
, dbIsValid
,
dbListFields
, dbListResults
,
dbListTables
, dbReadTable
,
dbRemoveTable
, dbSendQuery
,
dbSendStatement
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)