Whats the best way to INSERT (500-700) words into an MySQL database, for the purpose of a dictionary/histogram

Question

I have to create a histogram/dictionary of all words found in parsing an html file. This includes a dictionary of all words found, and a histogram of their frequency.

I cant think of how to do this with PHP/MySQL because there could be potentially 2000 words that would have to be INSERTED at once =/

Any ideas?

Answer 1

Just insert multiple records at one time, but, if one has an error the entire insert will fail.

http://www.desilva.biz/mysql/insert.html

"INSERT INTO beautiful (name, age)
  VALUES
  ('Helen', 24),
  ('Katrina', 21),
  ('Samia', 22),
  ('Hui Ling', 25),
  ('Yumie', 29)";

Answer 2

If you have that many entries, create a text file and use the LOAD DATA INFILE command.

http://dev.mysql.com/doc/refman/5.1/en/load-data.html