sqlForInsertDataFrame: Generate SQL INSERT Statement

In KWB-R/kwb.db: Functions supporting data base access

Generate SQL INSERT Statement

Description

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

KWB-R/kwb.db documentation built on Oct. 1, 2023, 4:10 a.m.