Query for data with the SELECT statement in MySQL

This sample chapter, taken from MySQL 5.0 Certification Study Guide, discusses how to use the SELECT statement in MySQL to retrieve information from database tables.

Learn how to use the SELECT statement to retrieve information from database tables. This information will help you prepare for the MySQL certification.

This sample chapter, taken from MySQL 5.0 Certification Study Guide, covers the following topics:

• Specifying which columns to retrieve and the table from which to retrieve them
• Using WHERE to identify the characteristics that define which records to retrieve
• Using ORDER BY to sort query results
• Using LIMIT to limit the output to a specific number of the rows retrieved
• Using DISTINCT to eliminate duplicates
• Computing summary values from groups of rows
• Using UNION to combine results from multiple queries into a single result set

Title: MySQL 5.0 Certification Study Guide
ISBN: 0672328127
Published: August 2005
Author: Paul Dubois, Stefan Hinz, Carsten Pedersen
Chapter: Chapter 9: Querying for Data
Published by Sams