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 days 8 hours ago
5 days 1 hour ago
1 week 1 day ago
4 weeks 3 days ago
16 weeks 5 days ago
17 weeks 2 days ago
18 weeks 1 day ago
20 weeks 5 days ago
30 weeks 2 days ago
42 weeks 5 days ago