Create SQL Tuples from a List

Create SQL Tuples from a List

listValuesToSql(x)

Arguments

x	a list defining key = value pairs

Value

vector of character strings each of which represents one assignment in x

Examples

x <- list(name = "Peter", birthday = as.POSIXct("1981-12-13"))

setCurrentSqlDialect("msaccess")
cat(listValuesToSql(x))
#> 'Peter',#1981-12-13#

# Note that the representation of a date and time is different in MySQL
setCurrentSqlDialect("mysql")
cat(listValuesToSql(x))
#> "Peter",'1981-12-13'