db_append_table: Append a Dataframe to a Table

Description Usage Arguments Value Details Examples

View source: R/RMariaDBHelper.R

Description

Send a dataframe to the database to append to a table.

Usage

1
db_append_table(df, tablename, conf_file = "~/.db_conf.yml", ...)

Arguments

df

(dataframe) A dataframe to append to a database table.

tablename

(character) A table name to receive additional records.

conf_file

(character) A file containing database connection parameters. (Default: "~/.db_conf.yml")

...

Additional arguments passed to RMariaDB::dbAppendTable().

Value

(integer) Number of affected (appended) rows.

Details

A dataframe will be sent to the database to be appended to an existing table.

Examples

1
2
3
4
## Not run: 
db_append_table(datasets::iris, "iris")

## End(Not run)

deohs/RMariaDBHelper documentation built on Dec. 31, 2020, 11:17 p.m.