dbUpdate | R Documentation |
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 )
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? |
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.