stor update for 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:

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