You are hereBlogs / nishantsinghin's blog / Delete duplicate rows in mysql
Delete duplicate rows in mysql
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 :)
delete bad_rows.*
from new_zipcodes as bad_rows
inner join (
select zipcode, MIN(id) as min_id
from new_zipcodes
group by zipcode
having count(*) > 1
) as good_rows on good_rows.zipcode = bad_rows.zipcode
and good_rows.min_id <> bad_rows.id;
- nishantsinghin's blog
- Login or register to post comments
Really your post is really very good and I appreciate it. It’s hard to sort the good from the bad sometimes, You write very well which is amazing. I really impressed by your post.
412-79 exam
JN0-100 exam
640-821 exam
70-562 exam
642-647 exam
70-624 exam
156-215 exam
70-652 exam
i think this is good,strange & appreciating.....there is no doubt in this that we are now in that kind of world where wer come across different and strange things happening in this world. Innovation is everywhere, personally I am also a fan of innovation, no matter in studies, technologies, science, beauty, fashion (but it should be good for human kind an "world).
1Y0-A05
HP0-S25
1Y0-A24
1Y0-A18
6101.1
156-215.70
1Z0-525
1Z0-531
Great, thanks for sharing this blog post. Fantastic. send flowers to mexico | send flowers to south africa
Such nice post. Its gives us very informative things. Thanks for sharing us. Don't stop your blogging. Keep it up.mcts 70-433// 70-647 vce// exam 70-662// 70-290 simulations// 70-667 vce// 70-513 book// e20-001 exam // ccnp 642-902//
That's a great work. This will help a lot of administrators to protect their website by removing such links. Thanks for this interesting post.
70-649 vce //
70-643 vce //
exam 70-685 //
exam 70-450 //
exam 70-686 //
70-663 vce //
70-659 vce //
70-648 vce //
I used to be more than happy to seek out this internet-site.I wanted to thanks in your time for this glorious read!! I positively enjoying each little bit of it and I have you bookmarked to check out new stuff you weblog post
motocross gear combos = = motorcycle clothing accessories = = biker clothing for women = = battery heated motorcycle gloves = = cheap motorcycle gloves = = fingerless motorcycle gloves = = motorcycle racing gloves = = best leather motorcycle jacket = =
I used to be more than happy to seek out this internet-site.I wanted to thanks in your time for this glorious read!! I positively enjoying each little bit of it and I have you bookmarked to check out new stuff you weblog post
testking 70-511 testking 70-401 testking 70-293 testking 642-359 testking 352-001 testking 642-145 testking 650-367 testking 650-379
This query can be improved by removing count(*) to count(id)
I used to be more than happy to seek out this internet-site.I wanted to thanks in your time for this glorious read!! I positively enjoying each little bit of it and I have you bookmarked to check out new stuff you weblog post....
Pass4sure 646-985
Pass4sure PRINCE2
Pass4sure 1z0-052
Pass4sure HP0-J48
Pass4sure 000-115
Pass4sure PK0-003
Pass4sure 650-297
Pass4sure 000-039