sqlUpdate: Custom SQL Query on existing connection

In gogonzo/oddsandsods: Miscellanous functions

Description

Custom SQL Query on existing connection

Usage

sqlUpdate(df_new, table_name, by = "id", addIndex = T, return_query = F)

Arguments

return_query	if TRUE function returns only character element with custom query
query	SQL query to be processed
...	arguments passed to query

Examples

iris$id = 1:nrow(iris)
sqlInsert(iris, table_name = "iris")
df = iris[1:5,]
df[1,1] <- NA
df[4,5] <- NA
df[2,2] <- ""
sqlUpdate(iris, table_name = "iris", by="id", addIndex=F, return_query = T)

gogonzo/oddsandsods documentation built on May 12, 2019, 1:35 a.m.