DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Lucian has posted 4 posts at DZone. View Full User Profile

Remove Mysql Duplicates

07.26.2010
| 917 views |
  • submit to reddit
        
delete from table1
USING table1, table1 as vtable
WHERE (table1.ID > vtable.ID)
AND (table1.field_name=vtable.field_name)