1. 

   jswenson Peon

   Messages:

   441

   Likes Received:

   5

   Best Answers:

   0

   Trophy Points:

   0

   #1

   I had this saved somewhere but seem to have lost it. Does anyone know the querry structure to run to make phpmyadmin delate all duplicate entries.
   
   For example, if the data in ROW1 of TABLE2 matches I want it to delete all but one of them.
   
   Any help appreciated.

    

   jswenson, Jan 17, 2008 IP
   
2. 

   maxt Active Member

   Messages:

   154

   Likes Received:

   1

   Best Answers:

   0

   Trophy Points:

   53

   #2

   I think this will help
   
   http://www.thescripts.com/forum/thread543189.html

    

   maxt, Jan 17, 2008 IP

• Log in with Facebook

Your name or email address:

Do you already have an account?

• No, create an account now.
• Yes, my password is:
• Forgot your password?

Stay logged in