MySQL Tutorials
Here you’ll find the start of a collection of articles primarily on MySQL. Some are for new developers, while others are for database administrators to help them to do their jobs. Many of these articles were published in software magazines. Click on the heading of the article to read it on this site; click on the name of the publication below the article’s description to see it on the site where it was originally published.MySQL Basics
This tutorial is an article for the beginner who wants to get started quickly without having to invest a lot of time and money in books on MySQL. It includes straightforward examples.
Retrieving Data
A basic tutorial for retrieving data from an existing MySQL database and its tables.
Adding Data
This basic tutorial explains how to add data to a MySQL database using the mysql client. It covers the INSERT, REPLACE, and UPDATE statements.
String Functions
In this basic tutorial, many string functions available in MySQL are covered. It provides examples for each, showing the more common syntax.
Time Functions
A basic to intermediate and extensive tutorial on working with time functions in MySQL. It covers storing, retrieving, altering, and formatting dates and times. Many examples are included.
Changing Time
A basic tutorial on working with time functions in MySQL. It covers storing time in a table column, retrieving it and formatting it to your preferred style. It also explains the process of altering dates. Many examples are provided.
Altering Tables
Once you get started with MySQL by creating tables and adding data, at some point you will need to alter your tables. This article explains the basics of using the ALTER TABLE statement and gives examples of the many clauses with it.
Back-Ups
Perhaps the best utility for making backups of MySQL's data is mysqldump. It's free with MySQL and it doesn't require you to shut down MySQL to use it. It retrieves data and table schema from each database and exports it all to a simple text file. It's quick and easy to use. This article explains the basics of how to use this utility and gives examples.
Importing Data
When you're migrating data or otherwise need to bulk import data into MySQL, you'll need to use a utility like mysqldump or the LOAD DATA INFILE statement in MySQL. This article explain how to use them.
MySQL in a Nutshell
If you work with MySQL regularly and need a book on the topic with an easy to follow writing style and helpful examples, please consider buying MySQL in a Nutshell. If you already have the first edition, the second edition recently came out: it’s much better than the first edition and has had some great reviews. Click on the cover art work here and you’ll be taken to Amazon’s site where you can purchase a copy and have it mailed to you.
