mySQL - remove duplicate rows

hi, Iam writing a python script that gets articles from a MySQL DB, splits the article in its words, gets all synonyms for that word and saves it back to the MySQL server.
the problem now is that there are duplicate synonyms for each article.

Iam using three tables:
articles with aID, article
synonyms with sID, synonym
and a correlation table corr with aID, sID

anyone got an idea how to remove duplicates from the tables synonyms and corr or a tip how to avoid this?

>>4
Take your edgy cat-v bandwagoning back to Reddit, Uriel.

There's a branch of mathematics behind relational database theory called relational algebra, and it's actually one of the more logically intensive fields of computer science, so I can understand why you code monkeys can't grasp it or harness its true power. Yes, mysqld to power your blog is overkill, but sqlite3 is extremely light, efficient and expressive. Suggesting flat files as an alternative is like suggesting bubble sort as an alternative to quick sort.