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.