sqlForInsert: Generate SQL INSERT statement

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

Generate SQL INSERT statement

Description

Generate SQL INSERT statement

Usage

sqlForInsert(
  tablename,
  fields,
  sqlSource,
  sourceAreValues = !grepl(sqlSource, "^SELECT"),
  ignore = FALSE
)

Arguments

tablename	table name
fields	field names, separated by comma
sqlSource	value tupels of form (value1.1, value1.2, value1.3, ...) (value2.1, value2.2, value2.3, ...) ... or SQL SELECT statement providing these tupels
sourceAreValues	if TRUE, sqlSource is expected to be an SQL query providing data to be inserted -> no keyword VALUES in generated SQL code
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

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