Generate SQL INSERT Statement

Generate SQL INSERT statement to insert values in a data frame

Usage

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