doUpdateFullQueryAnyAny_MS: doUpdateFullQueryAnyAny_MS

In RX-PBB/PBBMikesGeneral:

Description

SQL table update function

Usage

doUpdateFullQueryAnyAny_MS(con, tableName, dfFull, updateFields, batchSize)

Arguments

con	RMySQL connection
tableName	Table name to update
dfFull	data frame to update
updateFields	subset of fields to update or NULL for all fields
batchSize	number of rows to process, works well up to 2000, generally good up to 5000

Examples

statement<-paste("SELECT * FROM Alloc WHERE ItemID IN ",create_IDstring(Items$ItemID),";",sep='')

RX-PBB/PBBMikesGeneral documentation built on May 19, 2019, 6:20 p.m.