How to insert entire text file in a table column

[Haisam K. Ido]

I have the following table,

CREATE TABLE cp (
id INT(11) NOT NULL auto_increment,
file VARCHAR(128) NOT NULL,
content LONGTEXT,
UNIQUE KEY keyword(id,file),
PRIMARY KEY (id)
) TYPE=INNODB;

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.

Is there a way to give the path to a file and for mysql to use that path to insert the content?


---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php