© Kevin Languedoc 2016

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

6. Selecting Records

Kevin Languedoc

(1)Montreal, Canada

The SELECT statement is the workhorse of the SQL language no matter what platform you are using, and it is no different with SQLite. The SELECT statement is used to perform queries against a SQLite table or view. It is also used to populate views in SQLite databases, just as in other relational database systems.

This chapter demonstrates how to use SELECT in Swift by binding data from columns in SQLite tables and assigning them to Swift data-type variables.

The examples demonstrate how to perform SELECT queries to return text and numeric data as well as audio, image, and video data. ...

Get Build iOS Database Apps with Swift and SQLite now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.