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