sql_update: Updates an existing data table

In jeffchang5/SQLiter: SQLiteR

Description

Updates an existing data table

Usage

sql_update(tbl, set, where)

Arguments

tbl	- the table you'd like to perform an update on
set	- a list (or vector/matrix/data.frame) containing vectors of values you'd like to update the selected rows with. Each different column change should be an element. Each list element is a different query.
where	- a vector of where conditions for each of your updates

Examples

sql_update("table_1", list(c("c1 = 301", "c2 =307"), c("c1 =909")), c("c1=300","c1 =99"))

jeffchang5/SQLiter documentation built on May 19, 2019, 1:48 a.m.