Does the user mysql have search and read permissions to the directroy
and file you are trying to load?
Venugopal Allavatam wrote:
Hi All!
I am sorry that I posted that message with a syntactical error. but
what i meant to write was this..
insert into table_name(field_name1,data_file)
Are you trying to load the contents of a file with an INSERT statement? If
so, you can't. The values MUST be constants.
What are your really trying to do?
-Original Message-
From: Venugopal Allavatam [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 12:26 PM
To: Sinisa
oops...I'm wrong...you can load that way.
-Original Message-
From: Rick Emery
Sent: Monday, November 12, 2001 12:56 PM
To: [EMAIL PROTECTED]
Subject: RE: load_file problem
Are you trying to load the contents of a file with an INSERT statement? If
so, you can't. The values MUST
Hi All!
I am a newbie at mySQL. I need to implement a database which has the
capability to store some *.dat files. hence i have already implemented
a table using:
create table table_name (field_name1 int unsigned auto_increment
primary key not null, data_file longblob not null);
I then