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

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: http://www.mysql.com/doc/en/String_function