Speaking SQL (part 2)

After learning how to insert and edit data in a database, thesecond part of our SQL tutorial takes an in-depth look at the SELECTquery,and explains how to use joins, sub-queries and built-in functions tofocus in on the data you need.

TABLE OF CONTENTS:

By: icarus, (c) Melonfire

Poor Best

Rating:

/ 5

January 18, 2001

print this article

SEARCH DEV SHED

TOOLS YOU CAN USE

Last time out, I showed you how to get your data into a database with the INSERT statement, and edit it with the UPDATE and DELETE statements. And this time, I'm going to show you how to extract specific "slices" of data from your database using a variety of SELECT statements.

Let's get started!

This article copyright Melonfire 2001. All rights reserved.

Next: Christmas Presents >>



	>>> More MySQL Articles >>> More By icarus, (c) Melonfire

blog comments powered by Disqus

MYSQL ARTICLES

- Xeround Releases Free Version of MySQL Cloud...
- Oracle Announces New MySQL Specialization
- Constant Contact Chooses SkySQL for MySQL Su...
- Revoke Statement in MySQL
- The Grant Statement in MySQL
- SuccessBricks Announces ClearDB Availability...
- Building a PHP ORM: Deploying a Blog
- TROSYS Launches Free MySQL Manager and Admin...
- Building an ORM in PHP: Domain Modeling
- Building an ORM in PHP
- MySQL Leads Open Source Market, Gets Cluster...
- Oracle Announces Milestone Release for MySQL
- How to Stop SQL Injection Attacks
- New Defragmentation Solution for SQL Server
- Comparison of MyISAM and InnoDB MySQL Databa...

Find More MySQL Articles

DevShed

MySQL Tutorials

Speaking SQL (part 2)

See Also:

Dev Shed Tutorial Topics: