Member Avatar for rajeesh_rsn

Hai,

I had a database with tables id,name,email. ( Total about 25 thousand of rows in that database ) . I want to do mails to these email ids daily. Now in this condition so much email ids are repeating bcoz I converted a excel file to musql. It is impossible to delete the repeating mail ids manually. There is only one mail id in "email" column.

So my question is : there is any query or method to delete repeating rows... I am using PHP

Thanks in advance
Rajeesh

  • 2 Contributors
  • 1 Reply
  • 65 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by yalus
Member Avatar for yalus 
ALTER IGNORE TABLE table ADD UNIQUE INDEX(email)
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.