Head First SQL, 2nd Edition

Chapter 3. The SELECT Statement: Finding your Information

Finders keepers? When it comes to databases, chances are you’ll need to retrieve your data more often than you’ll need to insert it. In this chapter, you’ll get an up-close look at the powerful SELECT statement and learn how to gain access to that important information you’ve been putting in your tables. You’ll even meet the WHERE clause, which will help you selectively get the data you need and avoid displaying the rows you don’t need. So what do you say, let’s get going and find some SQL data.

Searching for a destination

Abby needs to find places that can be reached by car, so she tries the SELECT statement from Chapter 2 to view her table.

Relax

You can get a copy of locations.

You’re about to see a snippet of Abby’s full locations table. You don’t need to actually work with the table, but if you want access, you can get a copy of it and the entire travel_db database by visiting:

https://github.com/kimfetti/head_first_sql

Then see Appendix A for instructions on running a .sql file with MySQL.

Sharpen your ...