View source: R/get_sql_upsert.R
compares two data.frames and transforms the delta into SQL commands
1 2 | get_sql_upsert(new_df, old_df, key_col, tablename, add_method = "copy",
del_old = FALSE)
|
new_df |
A |
old_df |
A |
tablename |
The name of the database table to delete from |
add_method |
Specifies the import method (copy (default) or insert) |
del_old |
Boolean flag to specify if missing data in new_df should be deleted |
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.