Delete documents from an Infino table
infino_delete_documentsRemove rows matching a SQL predicate, such as status = 'spam', and get the count of deleted records. Verify the selection first with a count query to avoid unintended removal.
Instructions
Delete the rows matching a SQL predicate, e.g. "status = 'spam'". Returns how many rows matched and were removed. Check the predicate first with infino_count or infino_sql. Requires durable storage (not memory://).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Table to delete from. | |
| predicate | Yes | SQL predicate selecting the rows to delete, e.g. "status = 'spam'". |