Sqlite icon

Sqlite

Get, add and update data in SQLite

Actions5

Insert

AI-generated

Summary

Insert one or more new rows into a specified table in an SQLite database file.

Inputs

  • File DB (required) — Path of the SQLite database file to write the new rows into.
  • Table (required) — Name of the table in which to insert the new data rows.
  • Columns — Comma-separated list of column names that map to properties on each input item to use as columns for the new rows.

Output shape

a list containing a single object summarizing the result of the insert operation

The operation inserts data for all input items as new rows. If a property is missing on an input item for a given column, that column is set to null for that row. If the insert fails, an error is thrown or optionally returned if 'Continue On Fail' is enabled.

Links

Discussion