SqliteInstall

Summary

Update rows in a specified SQLite database table by matching a key column and setting new values for specified columns.

Inputs

• File DB (required) — Path of the SQLite database file to update records in.
• Table (required) — Name of the table in which to update data.
• Update Key (required) — Column name used to identify which rows to update (e.g., 'id').
• Columns — Comma-separated list of columns to update with new values from input items.

Output shape

a list of JSON objects representing the result of each update operation performed

Takes input items, uses the specified columns and update key to build UPDATE statements for each item. Returns database run results for all updates as output items. If any update fails and 'continueOnFail' is enabled, outputs error information instead of failing the node.

Links

• n8n community nodes installation guide