Re: How to insert entire text file in a table column

2003-01-13 Thread Stefan Hinz, iConnect \(Berlin\)
Haisam, I want to insert into content an entire text document. How do I do that without puting the entire content into a variable, let's say in perl, and then writing the INSERT statement. In MySQL, you have the LOAD_FILE() function to do this:

Re: How to insert entire text file in a table column

2003-01-13 Thread Haisam K. Ido
Excellent! It works. H M Kunzmann wrote: Yes there is ! Use LOAD_FILE(path_name) as the value component of the insert/update statement On Mon, 2003-01-13 at 00:41, Haisam K. Ido wrote: I have the following table, CREATE TABLE cp ( id INT(11) NOT NULL auto_increment, file