Chapter 3Retrieving and Updating Data

In Chapter 2, I briefly introduced you to the SELECT statement by using SELECT * to display all of the rows in the employee and address tables. But SELECT is certainly more powerful and flexible than that. It has the ability to retrieve only certain columns, filter and sort rows, and even select rows from multiple tables based on the relationships we’ve defined. You’ll learn how to use SELECT to do all that and more in this chapter and in Chapter 4.

I also promised to show you the UPDATE and DELETE statements so you’ll be able to perform the four basic data operations: creating rows, retrieving them, and keeping them current either by updating them or deleting them. You already know how to create rows, so ...

Get Jump Start MySQL now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.