dataFrameToSqlTuples: Create SQL Tuples from Data Frame
In KWB-R/kwb.db: Functions supporting data base access

dataFrameToSqlTuples

R Documentation

Create SQL Tuples from Data Frame

Description

Create SQL Tuples from Data Frame

Usage

dataFrameToSqlTuples(newData)

Arguments

newData

a data frame

Value

vector of character strings each of which represents one row in newData

Examples

x <- data.frame(
  name = c("Peter", "Paul"), 
  birthday = as.POSIXct(c("1981-12-13", "2003-01-16"))
)

setCurrentSqlDialect("msaccess")
dataFrameToSqlTuples(x)

# Note that the representation of a date and time is different in MySQL
setCurrentSqlDialect("mysql")
dataFrameToSqlTuples(x)

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