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
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