Insert rows into a table
The dbAppendTable() method assumes that the table has been created
beforehand, e.g. with dbCreateTable().
The default implementation calls sqlAppendTableTemplate() and then
dbExecute() with the param argument. Backends compliant to
ANSI SQL 99 which use ? as a placeholder for prepared queries don't need
to override it. Backends with a different SQL syntax which use ?
as a placeholder for prepared queries can override sqlAppendTable().
Other backends (with different placeholders or with entirely different
ways to create tables) need to override the dbAppendTable() method.
dbAppendTable(conn, name, value, ..., row.names = NULL)
conn |
A DBIConnection object, as returned by
|
name |
Name of the table, escaped with |
value |
A data frame of values. The column names must be consistent with those in the target table in the database. |
... |
Other arguments used by individual methods. |
row.names |
Must be |
The row.names argument is not supported by this method.
Process the values with sqlRownamesToColumn() before calling this method.
Other DBIConnection generics:
DBIConnection-class,
dbCreateTable(),
dbDataType(),
dbDisconnect(),
dbExecute(),
dbExistsTable(),
dbGetException(),
dbGetInfo(),
dbGetQuery(),
dbIsReadOnly(),
dbIsValid(),
dbListFields(),
dbListObjects(),
dbListResults(),
dbListTables(),
dbReadTable(),
dbRemoveTable(),
dbSendQuery(),
dbSendStatement(),
dbWriteTable()
con <- dbConnect(RSQLite::SQLite(), ":memory:") dbCreateTable(con, "iris", iris) dbAppendTable(con, "iris", iris) dbReadTable(con, "iris") dbDisconnect(con)
Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.