INSERT_INTO_VALUES: INSERT INTO tbl VALUES

Description Usage Arguments Examples

View source: R/sqrrl.R

Description

Inserts into a table the values in a vector or data.frame. Subsets the values by column name.

Usage

1
INSERT_INTO_VALUES(tbl, vals, cols = NULL)

Arguments

tbl

Table name to insert into

vals

Values for insertion, can be a vector or a data.frame

cols

Columns to include

Examples

1
2
3
INSERT_INTO_VALUES('table', 1:3)
INSERT_INTO_VALUES('table', c('a' = 1, 'b' = 2, 'c' = 3))
INSERT_INTO_VALUES('iris', iris[c(1, 51, 101), ], c("Sepal.Length", "Petal.Length", "Species"))

gadenbuie/sqrrrl documentation built on May 24, 2019, 4:04 a.m.