MySQL Cookbook

Section 14.0.  Introduction

Recipe 14.1.  Preventing Duplicates from Occurring in a Table

Recipe 14.2.  Dealing with Duplicates When Loading Rows into a Table

Recipe 14.3.  Counting and Identifying Duplicates

Recipe 14.4.  Eliminating Duplicates from a Table

Recipe 14.5.  Eliminating Duplicates from a Self-Join Result