Description Usage Arguments Examples
Delete records
1 |
conn |
A DBIConnection object |
table |
The table name to delete records from |
where |
A data frame of records to delete |
batch_size |
The number of records to delete in a single statement (defaults to all) |
1 2 3 4 5 6 7 8 9 10 | db <- dbxConnect(adapter="sqlite", dbname=":memory:")
table <- "forecasts"
DBI::dbCreateTable(db, table, data.frame(id=1:3, temperature=20:22))
# Delete specific records
bad_records <- data.frame(id=c(1, 2))
dbxDelete(db, table, where=bad_records)
# Delete all records
dbxDelete(db, table)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.