Databases
Find Duplicates in MySQL Find Duplicates in MySQL

Finding duplicate entries in a MySQL column.

Author: eharetea
Date Modified: 05/10/10

String Length in MySQL String Length in MySQL

Use the LENGTH() function in MySQL to determine string length.

Author: eharetea
Date Modified: 08/04/08

Get Subfolders Get Subfolders

Get all subfolders in a MySQL table using PHP.

Author: eharetea
Date Modified: 08/02/08

Select Statements Select Statements

Some example SELECT statements.

Author: eharetea
Date Modified: 08/02/08

Create new database Create new database

Flushing privileges, and creating a new database in MySQL.

Author: eharetea
Date Modified: 08/02/08

Sub Queries Sub Queries

Use sub-queries to perform a query inside of a query.

Author: eharetea
Date Modified: 08/01/08

Like Like

The LIKE statement in mysql.

Author: eharetea
Date Modified: 08/01/08

CMS CMS

An example of a content management system in MySQL.

Author: eharetea
Date Modified: 08/01/08

Normalizing Normalizing

A basic model of a normalized database.

Author: eharetea
Date Modified: 08/01/08

Fulltext Search Fulltext Search

Using fulltext searches in MySQL.

Author: eharetea
Date Modified: 08/01/08

Optimizing Optimizing

Use the EXPLAIN, ANALYZE, and SHOW statements to optimize queries.

Author: eharetea
Date Modified: 08/01/08

Alter Alter

Add or modify columns of a table using the ALTER statement in MySQL.

Author: eharetea
Date Modified: 08/01/08

Indexes Indexes

How to create indexes using the ALTER statement.

Author: eharetea
Date Modified: 08/01/08

Grouping Grouping

Group results by certain attributes.

Author: eharetea
Date Modified: 08/01/08

Join Join

Joining tables in a MySQL database.

Author: eharetea
Date Modified: 08/01/08

Date and Time Functions Date and Time Functions

MySQL time and date functions. .

Author: eharetea
Date Modified: 08/01/08

Functions Functions

An overview of some built-in functions in MySQL.

Author: eharetea
Date Modified: 08/01/08

Update Update

Use the UPDATE statement to update data in a table.

Author: eharetea
Date Modified: 08/01/08

Retrieving between dates Retrieving between dates

Retrieve data between two dates in MySQL.

Author: eharetea
Date Modified: 08/01/08

Conditions Conditions

Using AND, OR and other operators in MySQL.

Author: eharetea
Date Modified: 08/01/08

Create Create

MySQL CREATE statement is used in order to create tables.

Author: eharetea
Date Modified: 08/01/08

Insert Insert

Insert data into a database using the INSERT statement in MySQL.

Author: eharetea
Date Modified: 08/01/08

mysqldump mysqldump

Dump a mysql database to a .sql file.

Author: eharetea
Date Modified: 07/30/08