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.

Additional arguments

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.