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

People who downloaded this item also downloaded

Download 10 secret MySQL client startup options you should know
Book Chapters MySQL best practice techniques for efficient data retrieval and optimal data modification
Book Chapters MySQL performance tuning requires the monitoring of these two utility classes
Download 10 useful MySQL date and time functions
Book Chapters Optimize and tune MySQL

Top results from Training and Certification

Training Discover Windows 7 for only $99!
White Paper Systems Management in Healthcare Top 12 Best Practices
White Paper Windows 7: Tips and Best Practices for Simplified Migration
White Paper Simple Tricks to Ace the Subnetting Portion of Any Certification Exam
White Paper The New Generation of Microsoft Certifications: What's at the Core?

» View all Training and Certification listings

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