Re: How to insert entire text file in a table column

2003-01-13 Thread Stefan Hinz, iConnect \(Berlin\)
, 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, fileVARCHAR(128) NOT NULL, content LONGTEXT, UNIQUE KEY keyword(id,file), PRIMARY KEY (id

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