Generate SQL INSERT Statement

Source: R/sql_top_level.R

Generate SQL INSERT statement to insert values in a data frame

sqlForInsertDataFrame(tablename, dataFrame, ignore = FALSE, ...)

Arguments

tablename

table name
dataFrame

data frame with column names representing table field names
ignore

if TRUE the keyword IGNORE is inserted between INSERT and INTO in the SQL statement -> no error will be given if data to insert already exists
...

further arguments passed to sqlForInsert