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
t;[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, January 12, 2003 11:41 PM
Subject: How to insert entire text file in a table column
> I have the following table,
>
> CREATE TABLE cp (
> id INT(11) NOT NULL auto_increment,
> fileVARCHA
I have the following table,
CREATE TABLE cp (
id INT(11) NOT NULL auto_increment,
fileVARCHAR(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 wit