Description Usage Arguments Details Value See Also Examples
Helper function converting R code into SQL
SELECT
statements and data frames into
UPDATE
statements.
1 2 3 4 5 6 7 8 |
x |
Data frame or formula. |
where |
Character vector giving the name of the data frame and database table columns used to select rows. |
table |
Character scalar indicating the name of the database table to be updated. |
set |
Character vector giving the name of the data frame and database table columns to be updated. |
... |
Optional arguments passed between methods. |
The formula method saves some typing, particularly in the
case of complex queries, but it does not support joins.
R operators are mostly directly translated except for
those with the highest precedence. Infix operators are
translated literally. The control structures if
and function
yield CASE
constructs.
To use the data frame method to update a column, say,
"x"
that is also used to select rows, include
"x"
in the where
argument and
"new.x"
in the set
argument.
Character vector.
Other coding-functions: L
,
LL
, assert
,
case
, check
, collect
,
contains
, flatten
,
listing
, map_names
,
map_values
, must
,
set
, unnest
1 2 3 4 5 6 |
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.