O'Reilly logo

Using SQLite by Jay A. Kreibich

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

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

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