TXT to MySQL

[Warezov]

hello all

I have file something.txt where i have on every line one word. I have MySQl database witch have 2 columns. First collumn is primary key and the second is word from the something.txt. Why I do this?

[Warezov]

The wordlist have 7 044 000words.That is about 19Mb size.

[Jordan]

Usually a delimited file is used to import (CSV). I'm not sure if your file will import properly into two fields when you only have 1 word but you can try.

LOAD DATA INfile '/path/to/file' INTO TABLE <table> IGNORE 1 LINES

Import CSV file directly into MySQL | MySQL | Tech-Recipes