sqlTableInsertIntoTemplate: Generated parameterised template for inserting rows.

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

Description

Generated parameterised template for inserting rows.

Usage

sqlTableInsertIntoTemplate(con, table, values, row.names = NA, prefix = "?",
  ...)

Arguments

con	A database connection.
table	Name of the table. Escaped with dbQuoteIdentifier.
values	A data frame. Used only for the column names.
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.
prefix	Parameter prefix to put in front of column id.
...	Other arguments used by individual methods.

Examples

sqlTableInsertIntoTemplate(ANSI(), "iris", iris)

sqlTableInsertIntoTemplate(ANSI(), "mtcars", mtcars)
sqlTableInsertIntoTemplate(ANSI(), "mtcars", mtcars, row.names = FALSE)

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