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
1 week 3 days ago
1 week 3 days ago
1 week 6 days ago
5 weeks 2 days ago
17 weeks 4 days ago
18 weeks 1 day ago
19 weeks 9 hours ago
21 weeks 4 days ago
31 weeks 21 hours ago
43 weeks 3 days ago