appendTable: Append data to table.

In rocker: Database Interface Class

Append data to table.

Description

Append data to table.

Usage

appendTable(db, name, value, ...)

Arguments

db	rocker object
name	Table name
value	Values data.frame
...	Optional, additional suitable parameters passed to DBI::dbAppendTable()

Value

Number of appended rows invisibly

See Also

Other rocker-S3-functions: begin(), canConnect(), clearResult(), columnInfo(), commit(), connect(), createTable(), disconnect(), execute(), existsTable(), fetch(), getInfoCon(), getInfoDrv(), getInfoRes(), getQuery(), getRowCount(), getRowsAffected(), getStatement(), hasCompleted(), isValidCon(), isValidDrv(), isValidRes(), listFields(), listObjects(), listTables(), readTable(), removeTable(), rocker-README, rocker-S3-functions, rocker-package, rollback(), sendQuery(), sendStatement(), setupDriver(), setupMariaDB(), setupPostgreSQL(), setupSQLite(), unloadDriver(), validateCon(), writeTable()

Examples

db <- rocker::newDB()
rocker::setupSQLite(db)
rocker::connect(db)
rocker::createTable(db, "mtcars", mtcars)
rocker::appendTable(db, "mtcars", mtcars)
rocker::disconnect(db)
rocker::unloadDriver(db)

rocker documentation built on Aug. 21, 2022, 1:06 a.m.