I'm looking for a list of English dictionary words for a password application I'm working on.
Ideally the list can be easily inserted to a mysql database.
Any suggestions?
解决方案
Most Unix systems have a set of word lists, in my Ubuntu system it is on /usr/share/dict/american-english
A single word comes per line, so it's easy to insert if you really want it in a database.
This bash oneliner does it inefficiently:
cat /usr/share/dict/american-english \
| while read i; do echo insert into wordlist\(word\) VALUES \(\"$i\"\); done \
| mysql -u -p
This MySQL command does it efficiently (if the file is in the same machine):
LOAD DATA LOCAL INFILE '/usr/share/dict/american-english' INTO TABLE wordlist;