sqlSetClause: Compose an on clause for a table join

In schardtbc/DBIExt: Extentsion for DBI; new Generics

Description

'sqlSetClause()' generates a single SQL string that forms the set clause for an SQL Update statment two tables. The default methods are MariaDB, MySQL compliant. These methods are mostly useful for backend implementers.

Usage

sqlSetClause(con, x, y, set, ...)

Arguments

x, y	names of tbls to join. These will be quoted with dbQuoteIdentifier
set	a character vector of columns to match . To set different variables on x and y use a named vector. For example, 'by = c("a" = "b")' will translate to SET 'x.a' = 'y.b'. Character vectors will be escaped with [dbQuoteIdenitifer()].

See Also

Other SQL generation: sqlAddIndex, sqlAlterTableWithPrimaryKey, sqlDeleteAllRecords, sqlOnClause, sqlReplaceInTable, sqlUpdateTable

schardtbc/DBIExt documentation built on June 7, 2019, 2:39 p.m.