Chapter 5. The SELECT Command
The SELECT command is
used to extract data from the database. Any time you want to query or
return user data stored in a database table, you’ll need to use the SELECT
command.
In terms of both syntax and functionality, SELECT is the most complex SQL command. In most
applications, it is also one of the most frequently used commands. If you want to
get the most out of your database (and your database designs), you’ll need a solid
understanding of how to properly use SELECT.
Generally, the returned values are derived from the contents
of the database, but SELECT can also be used to
return the value of simple expressions. SELECT
is a read-only command, and will not modify the database (unless the SELECT is embedded in a different command, such as
INSERT INTO...SELECT).
Get Using 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.
