sqlInsert: Bulk insert

Description Usage Arguments Examples

Description

Bulk insert to database

Usage

1
sqlInsert(df, table_name, loop = F, ignore = FALSE)

Arguments

df

data frame to be inserted into database

table_name

name of table within connection

loop

specifies if each row will be inserted seperately. If FALSE all values will be inserted at once. Default = T

Examples

1
2
3
4
5
6
7
8
9
oddsandsods:::sqlCreateTable(iris, "iris")
iris2 <- iris[sample(1:nrow(iris),30000, replace=T), ]

sqlInsert(iris2,
          table_name = "iris",
          loop = F)
SQLInsertSplit(iris2,
               table_name = "iris",
               chunk_size = 10000)

elo2zero/oddsandsods documentation built on May 16, 2019, 3:04 a.m.