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