>_ IzzyLab

Topic breakdown

SQLite is an embedded database in a single file, without a separate server; you can work with it from the terminal using the sqlite3 utility. Changing already existing rows is done by the UPDATE operator: the SET part specifies which column to change and to what value, while WHERE limits which rows are affected. The key point — without WHERE ALL rows in the table get updated, so a condition selecting the right record is mandatory.

What's checked

  1. the widget item's stock equals 0
  2. the stock of other items is unchanged

What it looks like