Return Styles: Pseud0ch, Terminal, Valhalla, NES, Geocities, Blue Moon. Entire thread

mySQL - remove duplicate rows

Name: Anonymous 2012-11-20 11:17

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?

Name: Anonymous 2012-11-20 15:30

A good tip is: Databases considered harmful, use ndb or plain text files.

Newer Posts
Don't change these.
Name: Email:
Entire Thread Thread List