sqlTableInsertInto: Insert rows into a table.

In rstats-db/SQL: Safely Generate Common SQL Strings

Description

Insert rows into a table.

Usage

sqlTableInsertInto(con, table, values, row.names = NA, ...)

## S4 method for signature 'DBIConnection'
sqlTableInsertInto(con, table, values,
  row.names = NA, ...)

Arguments

con	A database connection.
table	Name of the table. Escaped with dbQuoteIdentifier.
values	A data frame. Factors will be converted to character vectors. Character vectors will be escaped with dbQuoteString.
row.names	Either TRUE, FALSE, NA or a string. If TRUE, always translate row names to a column called "row_names". If FALSE, never translate row names. If NA, translate rownames only if they're a character vector. A string is equivalent to TRUE, but allows you to override the default name. For backward compatibility, NULL is equivalent to FALSE.
...	Other arguments used by individual methods.

Examples

sqlTableInsertInto(ANSI(), "iris", head(iris))

sqlTableInsertInto(ANSI(), "mtcars", head(mtcars))
sqlTableInsertInto(ANSI(), "mtcars", head(mtcars), row.names = FALSE)

rstats-db/SQL documentation built on May 28, 2019, 3:35 a.m.