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 valu
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 Milivoj
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_f
> 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);
>
>
