ENTIRE text file => single record

jesmond23

Hi,

Here's the problem:

I wish to create a mysql database containing information on a collection (100-200) of text files, each file is about 10,000-20,000 words long, 100-300KB.

The database consists of one table, three fields:
filename (text)
location (text)
content (longtext)

My problem is with the third column - content. I want each record/cell in this column to contain the content of an entire text file in the collection. The type - longtext - should give ample storage space, but this is not my problem...

How do i tell mySql to read in the content of a text file and store it as a string in ONE cell?

I can make it populate an entire table from a text file but this is not what i want.

Any help gratefully received!!!

Thanks,

Pete

mahers

Not sure if this is of any help. The LOAD_FILE() function.

http://www.mysql.com/doc/en/String_functions.html#IDX1188

kristianblom

I probably would have created a little perl script to do the magic for me.

jayant

How about something like:

...
$file_content=implode ('',file("$path_to_file","r"));
mysql_query("INSERT INTO .....");
...

simple 🙂
$file_content variable will have the content of whole file. Pass it in the mysql_query function.