On TechRepublic: Five super-secret features in Windows 7
BNET Business Network:
BNET
TechRepublic
ZDNet

FREE Registration is required

Overview:

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

(Is this item miscategorized? Does it need more tags? Let us know.)

Format:PDFSize:244 KB
Date:Feb 2006Version:1.0
License:copyright
System Req: Acrobat Reader 5.0 or later
advertisement

White Papers, Webcasts, and Resources

Featured Training Courses

advertisement
Click Here

SmartPlanet

Click Here

Returning users: Log In Here!

Already registered on BNET, TechRepublic, or ZDNet? Simply log in.

Free Membership: Sign Up Now!

Sign up for a free membership today and get instant and unlimited access to one of the largest databases of white papers, webcasts, and casestudies anywhere. Your FREE membership allows you to:

  • Download an unlimited amount of content, including classic and current white papers, case studies, webcasts and more
  • Track content on your chosen topics of interest
  • Receive targeted email alerts when your favorite content is added
  • Save content for future reading
  • Receive our member newsletter

When you register to access this library, you allow us to share your information with companies that produce products or services featured in the library--so that such companies may contact you with information and offers regarding their products and services. This enables us to keep the library a free service. As a library registrant, you will receive a complimentary subscription to the ZDNet white paper newsletter and e-mail Must-Read News Alerts. You can unsubscribe from these at any time. By clicking the Sign up button, you indicate that you agree to our Terms and Conditions and have read and understand our Privacy Policy (updated).