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

How to insert entire text file in a table column

2003-01-12 Thread Haisam K. Ido
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