Showing posts with label ignore. Show all posts
Showing posts with label ignore. Show all posts

Wednesday, September 16, 2009

MySQL Handling Duplicates

Tables or result sets sometimes contain duplicate records. Sometime it is allowed but sometime it is required to stop duplicate records. Sometime it is required to identify duplicate records and remove them from the table. This chapter will describe how to prevent duplicate records occurring in a table and how to remove already existing duplicate records.