database

Update information in a specified table in the in-memory sqlite database.

Signature

> stor update {flags}

Flags

• --table-name, -t {string}: name of the table you want to insert into
• --update-record, -u {record}: a record of column names and column values to update in the specified table
• --where-clause, -w {string}: a sql string to use as a where clause without the WHERE keyword

Input/output types:

input	output
nothing	table
record	table

Examples

Update the in-memory sqlite database

> stor update --table-name nudb --update-record {str1: nushell datetime1: 2020-04-17}

Update the in-memory sqlite database with a where clause

> stor update --table-name nudb --update-record {str1: nushell datetime1: 2020-04-17} --where-clause "bool1 = 1"

Update the in-memory sqlite database through pipeline input

> {str1: nushell datetime1: 2020-04-17} | stor update --table-name nudb