Generate SQL UPDATE Statement

Generate SQL UPDATE Statement

Usage

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