SQLite UPDATE statement

The SQLite UPDATE statement is used to updated existing table entries in a SQLite database.

This is one example:

UPDATE customers
SET leadtime = 3
WHERE priority < 6;

This sets the leadtime to 3 days for all customers for a priority score of less than 6.