Remove duplicates from mysql with no primary key

Question

   select count(distinct (mobile)) from number_data where value = 'A_HNI';

   count(distinct (mobile)) = 5046082 



  select count(mobile) from number_data where value = 'A_HNI';

  count(mobile) = 9658150

There are 4612068 duplicates of mobile numbers in value = 'A_HNI'. I want to delete the duplicates and keep the original . The table has no primary key nor indexing . I can't assign a primary key but indexing is possible . The table is as follows :

Field Type Null Key Default Extra

age | varchar(255) | YES | | NULL | |

dnd | varchar(255) | YES | | NULL | |

msc | varchar(255) | YES | | NULL | |

Which of the duplicates do you want to keep? – Bohemian Sep 06 '14 at 07:35 — Bohemian, Sep 06 '14 at 07:35

score 1 · Answer 1 · edited May 23 '17 at 10:33

1

Get the Distinct value from your table ,create a new table with it then delete the old table For reference you can check this page Remove Duplicate Value

You can also refer this stack answerenter link description here

edited May 23 '17 at 10:33

Community

1
1

answered Sep 06 '14 at 05:53

Domain

11,562
3
23
44

I have multiple clauses example where value = 'A_HNI' , where value = 'a' , where value = 'b'. so i have to create separate table for each and then combine them ?? – It Insign Technology Sep 06 '14 at 06:01

Remove duplicates from mysql with no primary key

1 Answers1