Delete duplicate rows in mysql
Tags:
Submitted by nishantsinghin on Thu, 11/13/2008 - 15:58.
Tags : delete duplicate row
Description : I want delete duplicate zipcode from zipcode table, in that table i have zipcode field, which one have duplicate zipcods. After searching and help of Suresh we have got the solution to delete duplicate records, but in that table u have need one filed as primary key. In this query id is working as primary key. See b below for the that terriffic query :)

Recent comments
4 weeks 5 days ago
17 weeks 1 day ago
17 weeks 1 day ago
17 weeks 4 days ago
17 weeks 5 days ago
27 weeks 2 days ago
27 weeks 4 days ago
28 weeks 6 days ago
29 weeks 21 hours ago
29 weeks 6 days ago