Date/Time Functions In MySQL

Get a crash course in MySQL's date and time functions | 19 Jan 2004

Strings In MySQL

Use the powerful string processing toolkit in MySQL for common string manipulation tasks | 18 Dec 2003

Using Transactions In MySQL (part 2)

Learn to avoid data corruption with MySQL's various isolation levels, and see examples of transaction usage at the application level | 12 Sep 2003

Using Transactions In MySQL (part 1)

Implement a transactional environment with MySQL | 08 Sep 2003

Using Subqueries In MySQL (part 2)

Do more with subqueries with the IN and EXISTS operators | 25 Jul 2003

Using Subqueries In MySQL (part 1)

Build sophisticated nested queries with MySQL 4 | 18 Jul 2003

Date Arithmetic With MySQL

Simplify date and time arithmetic with built-in MySQL functions | 27 Jun 2003

Understanding SQL Joins

Left join. Right join. Inner join. Welcome to the wild, the wacky, the insanely cool world of SQL joins | 13 Aug 2002

Access Granted

Precisely control access to information with the mySQL grant tables | 18 Apr 2001

Database Essentials

A discussion of basic database concepts | 23 Feb 2001

all articles

next page