db_updateRow: updates values in rows from a table in the database specified...

View source: R/dbAccess.R

db_updateRowR Documentation

updates values in rows from a table in the database specified by the 'where' argument

Description

updates values in rows from a table in the database specified by the 'where' argument

Usage

db_updateRow(db, tableName, values, where = NA)

Arguments

db

database access 'handle'

tableName

name of the table

values

character vector specifying which columns get a new value, eg: c("age = 55", "gender = 'F'")

where

allows for conditional retrieving, should be in the form of a character vector specifying the conditions and boolean operators, eg: c("age = 45", " AND ", "gender = 'M'). if this parameter is NA, then nothing happens

Value

nothing


BenBruyneel/BBPersonalR documentation built on Aug. 23, 2024, 8:28 p.m.