mySql analyze tools - any suggestions ?

Discussion in 'MySQL' started by retry, Apr 14, 2009.

0
  1. #1
    Hi, I'm in need of a tool.

    I have two types of lists which I need to compare. All stored in a mysql database.

    The first list. I store 1000 keywords each day in a table. The table grows bigger and bigger. I need some kind of tool to analyze the database. I would like to be able to find duplicates in that table.

    The secound thing, is also lists of keywords. However this is somewhat different. In these lists there are no duplicates. However I would like to compare the lists, to find similiar entries.

    Do you know if there is a tool for me?

    Regards

    Retry
     
    retry, Apr 14, 2009 IP
  2. jimbursch

    jimbursch Peon

    Messages:
    33
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    To find duplicates:

    SELECT keywords, COUNT(keywords) AS keywordcount FROM list GROUP BY keywords HAVING keywordcount > 1 ORDER BY keywordcount DESC

    Finding similarities depends on how you define similarities.
     
    jimbursch, Apr 15, 2009 IP
  3. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #3
    You can also set a unique key in a column to prevent duplicates.
     
    jestep, Apr 15, 2009 IP
  4. retry

    retry Active Member

    Messages:
    263
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    73
    #4
    Thanks for the tips. I'm not looking to remove duplicates. I'm looking to find the duplicates, and how many of those there are.

    On a month basis I would like to find out how many times a keyword has appeared in the list.
     
    retry, Apr 15, 2009 IP