Update a row in a database table

Update a row in a database table

dbUpdate(
  db,
  table,
  vals,
  where = NULL,
  schema = schemas[[table]],
  schemas = get.db.schemas(db),
  sql = NULL,
  run = TRUE,
  rclass = schema$rclass,
  convert = !is.null(rclass),
  null.as.na = TRUE,
  log.dir = NULL,
  do.log = !is.null(log.dir),
  user = NA,
  where.in = FALSE
)

Arguments

db	dbi database connection
table	name of the table
vals	named list of values to be inserted
where	named list that specifies the keys where to update
schema	a schema as R list, can be used to automatically convert types
sql	optional a parameterized sql string
run	if FALSE only return parametrized SQL string
rclass	the r class of the table columns, is extracted from schema
convert	if rclass is given shall results automatically be converted to these classes?
null.as.na	shall NULL values be converted to NA values?