Entering Queries
This section describes the basic principles of entering commands, using several queries you can try out to familiarise yourself with how mysql works.

Mysql Sub Queries, introduction
Mysql now offers sub queries/sub selects. They can help you write faster and shorter code. You don't need to do that much programming in PHP, just let mysql do the work :-)

Optimizing MySQL Queries and Indexes
Building a database-driven site is one thing. But all too often your masterpiece starts performing like a donkey when it becomes popular. Learn how to optimize your queries and indexes in MySQL, and potentially speed up your application many times over.

Basic SQL optimization for MySql
It's important to know how to write your queries fast. And there are also ways to do your queries faster Inside mysql, called Indexes. They help mysql do the work faster, but you need to tell how...

MySQL Date Queries
Don't use PHP to calculate date ranges; you can build the date range inquiry directly into your MySQL query. Here are some common examples of MySQL date queries.

[MYSQL] functions/queries list
A list of usefully mysql functions and queries with short description for each function and exmaples.

Combining Queries
In this tutorial you'll learn how to use the UNION operator to combine multiple SELECT statements into one result set.

Connecting to and Disconnecting from the Server
Before you can start running your queries you need to get your client talking with your server.

Writing SELECT queries for SQL databases
When you want to get results from a database you issue a select query. With this query you can limit the results based on certain criteria, sort it, and subsort it. You can do a lot with this including selecting data from multiple tables.

Optimizing MySQL, Hardware and the Mysqld Variables
You've fine-tuned your indexes, and have optimized those queries to the bone. But still your MySQL database is crawling. It's time to look at tweaking the mysqld variables, what hardware improvements you can make, and how you can compile MySQL to run just that little bit faster.

Using mysql in Batch Mode
You've probably used mysql interactively to enter queries and view the results. You can also run mysql in batch mode.

Build Your Own Database Driven Website Using PHP & MySQL: Part 4
This final installment covers publishing MySQL data on the Web, connecting to MySQL with PHP, sending SQL queries with PHP, inserting data into the database, and even has a "homework" assignment. This book covers everything from installing PHP & MySQL under Windows or Linux, through to building a live Web-based content management system.

MySQL and SQL
This tutorial covers the following:
Introduction to relational databases and relational modeling; The MySQL command interpreter and the basic features of MySQL; Using SQL to create and modify databases, tables, and indexes. Using SQL to insert, delete, and update data; The SQL SELECT statement for querying, with examples of simple and advanced queries; Functions and operators in SQL and MySQL; Advanced features, including managing indexes and keys, tuning the MySQL DBMS, security, and the limitations of MySQL