Find Duplicates in MySQL

Finding duplicate entries in a MySQL column.

String Length in MySQL

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

Get Subfolders

Get all subfolders in a MySQL table using PHP.

Select Statements

Some example SELECT statements.

Create new database

Flushing privileges, and creating a new database in MySQL.

Sub Queries

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

Like

The LIKE statement in mysql.

CMS

An example of a content management system in MySQL.

Normalizing

A basic model of a normalized database.

Fulltext Search

Using fulltext searches in MySQL.

Optimizing

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

Alter

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

Indexes

How to create indexes using the ALTER statement.

Grouping

Group results by certain attributes.

Join

Joining tables in a MySQL database.

Date and Time Functions

MySQL time and date functions. .

Functions

An overview of some built-in functions in MySQL.

Update

Use the UPDATE statement to update data in a table.

Retrieving between dates

Retrieve data between two dates in MySQL.

Conditions

Using AND, OR and other operators in MySQL.

Create

MySQL CREATE statement is used in order to create tables.

Insert

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

mysqldump

Dump a mysql database to a .sql file.