MySQL Table Types
When you create a new table, you can tell MySQL what type of table to create.

Getting Information About Databases and Tables
What if you forget the name of a database or table, or what the structure of a given table is (for example, what its columns are called)? MySQL addresses this problem through several statements that provide information about the databases and tables it supports.

MySQL Tutorials - Table Column Types for Different Types of Values
This provides tutorial notes on table column types. Topics include column types for character strings, bit strings, exact numbers, approximate numbers, data and time values.

Creating a Table
Once you have a database, it's time to make some tables.

Retrieving Information from a Table
The SELECT statement is a MUST if you plan on using databases.

Creating & Manipulating Tables
In this tutorial you'll learn the basics of table creation, alteration, and deletion.

5 Useful MySQL Functions And Control Flows
If statements have been a life saver on many occasions. They are invaluable for checking a value then returning another value different from the one stored in the table...

Summarizing Data
In this tutorial, you will learn what the SQL aggregate functions are and how to use them to summarize table data.

Retrieving Data
In this tutorial, you'll learn how to use the SELECT statement to retrieve one or more columns of data from a table.

Updating & Deleting Data
In this tutorial, you will learn how to use the UPDATE and DELETE statements to enable you to further manipulate your table data.

Creating Advanced Joins
In this tutorial, you'll learn all about additional join types what they are and how to use them. You'll also learn how to use table aliases and how to use aggregate functions with joined tables.

Working with MySQL
In this tutorial, you'll learn how to connect and login to MySQL, how to issue MySQL statements, and how to obtain information about databases and table.

Build Your Own Database Driven Website Using PHP & MySQL: Part 2
This second installment covers an introduction to databases, logging on to MySQL, defininfg SQL, inserting data into a table, and modifying stored data.

Grouping Data
In this tutorial, you'll learn how to group data so you can summarize subsets of table contents. This involves two new SELECT statement clauses: the GROUP BY clause and the HAVING clause.