sqlAppendTable {DBI} | R Documentation |
sqlAppendTable
generates a single SQL string that inserts a
data frame into an existing table. sqlAppendTableTemplate
generates
a template suitable for use with dbBind()
.
These methods are mostly useful for backend implementers.
sqlAppendTable(con, table, values, row.names = NA, ...) sqlAppendTableTemplate(con, table, values, row.names = NA, prefix = "?", ...)
con |
A database connection. |
table |
Name of the table. Escaped with
|
values |
A data frame. Factors will be converted to character vectors.
Character vectors will be escaped with |
row.names |
Either If A string is equivalent to For backward compatibility, |
... |
Other arguments used by individual methods. |
prefix |
Parameter prefix to put in front of column id. |
sqlAppendTable(ANSI(), "iris", head(iris)) sqlAppendTable(ANSI(), "mtcars", head(mtcars)) sqlAppendTable(ANSI(), "mtcars", head(mtcars), row.names = FALSE) sqlAppendTableTemplate(ANSI(), "iris", iris) sqlAppendTableTemplate(ANSI(), "mtcars", mtcars) sqlAppendTableTemplate(ANSI(), "mtcars", mtcars, row.names = FALSE)