Updates an existing row based on primary keys. Only one row is updated.
modify_entry(con = NULL, tbl = NULL, ...)
Arguments
- con
DBI connection object.
- tbl
Name of the target table.
- ...
Named column-value pairs for the row to update.
Examples
if (FALSE) { # \dontrun{
con <- DBI::dbConnect(RSQLite::SQLite(), ":memory:")
modify_entry(con, "my_table", id = 1, name = "Updated", value = 20)
} # }