Database reference and Breaking .txt to database.

[system]

Hello guys.
I want to create a translator. I’ve collected 100,000 English words in text file. the file size is 1MB. I can’t query from text file or add translated words there so i want to query all these words into a database. Please tell me what is your suggestion which database is good to use there since i have a huge amount of data and after translation that’s gonna be more huge…

English words in .txt file.
Word1
Word2
…so on (Breaking line after)

How can i query these all to database. I don’t want to enter manually.

Thanks…
Ahmadzai.

[astonecipher]

Without giving you code,

The process would be

open the file,
Read a line,
Insert it into the table,
Repeat.

MySQL is normally used, but it’s up to you. Everyone thinks they have a huge amount of data, the majority of people rarely do.

[JimL]

1MB is a tiny data set so you don’t need any special process for this, just loop an insert.

To put it in perspective, stack overflows database weighs in at 1.7TB