SQL Relational Database Query Language Reference and Examples

The Tables
The Tables used in all examples
The Select Statement
Select Basics
Between - Finding data in a range
Group By - Putting data into groups
In and Not In - Matching or excluding a list of specific values
Join - Using multiple tables
Like - Matching strings
Order By - Putting rows in an order
Subselects - A select within a select
SQL Functions
Avg() - Average for a column
Count() - Count up rows
Count (Distinct) - Count up unique rows
Max() - Find the row with the largest value
Min() - Find the row with the smallest value
Sum() - Total up a column
Delete, Insert, and Update
Delete - Getting rid of rows
Insert - Adding rows
Update - Changing rows
More SQL
Views - Creating and using a simple view
Cartesian Joins - Cartesian joins and products
Cursor Processing with DB2
Cursor Processing with Oracle
SQL Comments and Questions
SQL Books
MySQL
A MySQL Database backup utility in PHP
A MySQL Table Add Column Function in PHP