SQLiteInstall

Summary

Update rows in a SQLite table using each input item to supply match values and values to set. Requires at least one match column; without explicit Update Columns, sets every input field except the match fields.

Inputs

• Database File Path Override — Optional absolute database file path; overrides the credential path and Base Directory settings.
• Database — Optional database file path relative to the credential’s Base Directory; ignored when Database File Path Override is set.
• Read Only — Opens the database read-only. The SQLite engine rejects writes when enabled.
• Confirm Destructive Operation — Allows guarded operations such as UPDATE without a WHERE clause. This update operation builds a WHERE clause from its required match columns.
• Execution Mode — Choose Independent to run one statement per input item, or Transaction to run items in a transaction and roll back on an error. Multi-Row Insert is for insert operations.
• Table (required) — SQLite table to update.
• Match Columns (required) — Select one or more columns used to match rows. Their values are read from each input item and combined with AND conditions.
• Update Columns — Columns to set from each input item. If empty, every item field except the match columns is set.

Output shape

One output item per input item when an update succeeds; each contains changes and lastInsertRowid.

Each input item produces its own UPDATE statement. Values for both SET and match conditions come from that item’s JSON fields; the operation errors if no match columns or no SET columns are available. With Transaction mode, any item error rolls back the transaction. If Continue On Fail is enabled, errors are returned as {error} items.

Links

• n8n community nodes installation guide