dbInsertOrReplace: Save records from a data frame into a db table, replacing...
In MotusWTS/motusServer: Operate a server to process data for http://motus.org
View source: R/dbInsertOrReplace.R
dbInsertOrReplace R Documentation
Save records from a data frame into a db table, replacing
existing records when primary keys collide.
Description
Seems like an obvious missing piece of the DBI. Ideally,
dbWriteTable would have a boolean 'replace' argument that served
the same purpose; i.e. record-wise overwrite, rather than
table-wise.
Usage
dbInsertOrReplace(con, name, df)
Arguments
con
DBI database connection
name
name of table to insert or replace records into
df
data from from which to write data.
Value
no return value
Author(s)
John Brzustowski jbrzusto@REMOVE_THIS_PART_fastmail.fm
MotusWTS/motusServer documentation built on Dec. 3, 2024, 10:47 a.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
View source: R/dbInsertOrReplace.R
| dbInsertOrReplace | R Documentation |
Save records from a data frame into a db table, replacing existing records when primary keys collide.
Description
Seems like an obvious missing piece of the DBI. Ideally, dbWriteTable would have a boolean 'replace' argument that served the same purpose; i.e. record-wise overwrite, rather than table-wise.
Usage
dbInsertOrReplace(con, name, df)
Arguments
con |
DBI database connection |
name |
name of table to insert or replace records into |
df |
data from from which to write data. |
Value
no return value
Author(s)
John Brzustowski jbrzusto@REMOVE_THIS_PART_fastmail.fm
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.