MySQueaL Resources

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.

Getting Data out of MySQL

A basic tutorial for retrieving data from an existing MySQL database and its tables.

Adding and Changing Data in MySQL

This basic tutorial explains how to add data to a MySQL database using the mysql client. It covers the INSERT, REPLACE, and UPDATE statements.

MySQL String Functions

In this basic tutorial, many string functions available in MySQL are covered. It provides examples for each, showing the more common syntax.

Doing Time with MySQL

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 Times in MySQL

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 in MySQL

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.

Making Backups with mysqldump

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 with MySQL

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.