Description Usage Arguments Value Examples
Insert rows into a table. If the table has key, it will ignore the duplicate rows indexed by the key. It assumes that the table has been created beforehand.
1 | dbAppendTableNew(conn, name, value, ...)
|
conn |
A |
name |
Name of the table. |
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. |
Number of rows appended successfully.
1 2 3 4 5 6 | con <- DBI::dbConnect(RSQLite::SQLite(), ":memory:")
DBI::dbWriteTable(con, "iris", iris[0, ])
flightscanner:::dbAppendTableNew(con, "iris", iris)
df <- DBI::dbReadTable(con, "iris")
head(df)
dbDisconnect(con)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.