Updating records in SQLite is very similar to using the UPDATE statement on other platforms like SQL Server or Oracle. However, SQLite offers additional operations for updating records that are similar in nature to the SQLite INSERT statement.
In this chapter, we will discuss the various ways we can use the UPDATE statement in SQLite. These include the following:
The UPDATE statement
The WHERE clause
The LIMIT and ORDER BY clauses
Using sub-queries
Using joins
Using a WHERE clause in a sub-query
Using the ON Conflict clause
The OR FALLBACK statement
The OR ABORT statement
The OR REPLACE ...
