O'Reilly logo

Build iOS Database Apps with Swift and SQLite by Kevin Languedoc

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© Kevin Languedoc 2016

Kevin Languedoc, Build iOS Database Apps with Swift and SQLite, 10.1007/978-1-4842-2232-4_7

7. Updating Records

Kevin Languedoc

(1)Montreal, Canada

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required