Generate SQL UPDATE Statement

Source: R/sql_top_level.R

Generate SQL UPDATE Statement

sqlForUpdate(tablename, keyValues, whereClause, ignore = FALSE)

Arguments

tablename

table name
keyValues

assignments as list of key=value pairs with the keys representing valid fields of table tablename
whereClause

where condition
ignore

if TRUE the keyword IGNORE is inserted between UPDATE and INTO in the SQL statement -> no error will be given if updating fails, e.g. because of key constraints