dbInsertInto: A safe variant of dbWriteTable

In mpio-be/sdb: Database Tools

A safe variant of dbWriteTable

Description

dbWriteTable(tempTable) –> insert into select .. from –> drop tempTable

Usage

dbInsertInto(con, name, x)

Arguments

con	a *Connection object
name	table name
x	data.table

Examples

## Not run: 
x = data.table(f1 = rep('a', 10), f2 = rnorm(10), f3 = 1)
con = dbcon('mihai', host = '127.0.0.1', db = 'tests')
dbq(con, 'CREATE TABLE temp (f1 VARCHAR(50) NULL,f2 FLOAT NULL)' )
dbInsertInto(con, 'temp', x)
dbq(con, 'DROP TABLE temp')

## End(Not run)

mpio-be/sdb documentation built on Nov. 18, 2022, 12:24 a.m.