Articles

 MySQL Admin

This lesson covers the different options you have available to you for administering your MySQL...

 MySQL Backup

If you're storing anything in MySQL databases that you do not want to lose, chances are you...

 MySQL Connect

Before you can do anything with MySQL in PHP you must first establish a connection to your web...

 MySQL Count

This lesson will teach you how to use the aggregate function COUNT(). If you missed the Aggregate...

 MySQL Create Table

A MySQL table is completely different than the normal table that you eat dinner on. In MySQL and...

 MySQL Database

A MySQL database is nothing in itself. Rather a MySQL database is a way of organizing a group of...

 MySQL Delete

Maintenance is a very common task that is necessary for keeping MySQL tables current. From time...

 MySQL Fetch Array

MySQL doesn't have a Fetch Array function. mysql_fetch_array is actually a PHP function that...

 MySQL Group By

After you have mastered the basics of MySQL, it's time to take the next step and take on...

 MySQL Insert

When data is put into a MySQL table it is referred to as inserting data. When inserting data it...

 MySQL Introduction

MySQL is currently the most popular open source database server in existence. On top of that, it...

 MySQL Join

Thus far we have only been getting data from one table at a time. This is fine for simple tasks,...

 MySQL Left Join

In the previous lesson, Mysql Joins we learned how to do a basic join of two tables. This lesson...

 MySQL Order By

It would be nice to be able to make MySQL results easier to read and understand. A common way to...

 MySQL Query

So far we have seen a couple different uses of PHP's mysql_query function and we'll be seeing...

 MySQL SQL Injection

If you have ever taken raw user input and inserted it into a MySQL database there's a chance that...

 MySQL Select

You have seen two types of MySQL queries thus far: the query which we used to create a table and...

 MySQL Setup

The easiest way to experiment with MySQL and PHP is to purchase some space on a shared web host....

 MySQL Sum

This lesson will teach you how to use the aggregate function SUM(). If you haven't already read...

 MySQL Syntax

The great thing about everything you do in MySQL is that the "code" is very easy for humans to...

 MySQL Update

Imagine that you have a MySQL table that holds the information of all the employees in your...

 MySQL Where

In a previous lesson we did a SELECT query to get all the data from our "example" table. If we...

 MySql Avg

This lesson will teach you how to use the aggregate function AVG(). If you missed the Aggregate...

 MySql Date Format

MySQL comes with several data types for storing a date in its database system: DATETIME, DATE,...

 MySql Index

Hardware enthusiasts have been overclocking their PCs for years now, trying to push the limits of...

 MySql Max

This lesson will teach you how to use the MAX() aggregate function . If you missed the Aggregate...

 MySql Min

This lesson will teach you how to use the aggregate function MIN(). If you missed the Aggregate...

 MySql Time Format

There are three different types of time data types in MySQL: TIME, DATETIME, and TIMESTAMP. If...