Part II. Querying and Updating Data
One statement in particular forms the core of SQL and clearly represents the nonprocedural nature of SQL: the SELECT
statement. It is the showpiece of SQL and, consequently, MySQL. This statement is used to query data in the tables; the result is always a table. Such a result table can be used as the basis of a report, for example.
This book deals with the SELECT
statement in Chapters 5–15. Each chapter is devoted to one or two clauses of this statement. Several chapters have been added to explain certain concepts in more detail.
Chapter 16, “The HANDLER
Statement,” is devoted to the HANDLER
statement, which offers an alternative method to query data. In a more simple way, rows can be retrieved individually. ...
Get SQL for MySQL Developers: A Comprehensive Tutorial and Reference 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.