dbDeleteAllRecords: delete all records in an existing table

In schardtbc/DBIExt: Extentsion for DBI; new Generics

Description

The default 'dbDeleteAllRecords()' method performs checks that the targeted table exists

Usage

dbDeleteAllRecords(con, name, key.df = NULL, ...)

Arguments

con	a DBConnection oject
name	a character string specifying the name of an existing DBMS table
key.df	NULL | a dataframe of key value pairs designating records to delete

Details

The sql generation uses the function 'sqlDeleteAllRecords()' another S4 generic defined in this package. Default sql generation is appropriate for MariaDB and MySQL.

See Also

Other DBIConnection generics: dbAddIndex, dbAddPrimaryKey, dbDropTable, dbReplaceInTable, dbUpdateTable

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