Problem
Mysql version 3.23.39 Linux version
SQL: INSERT INTO Pictures(Pers_ID, Picture) VALUES (1,
LOAD_FILE('\Database\pictures\1.bmp'));
above sql works fine.
Mysql version 3.23.49-max Windows version
SQL: INSERT INTO Pictures(Pers_ID, Picture)
Hello,
function load_file always return NULL for me.
I tried using INSERT and UPDATE. The file and directory is
world readable. Is there a known problem with load_file on
mysql 4.0.0 ?
INSERT INTO tests (Name,Data) VALUES
('123.456',LOAD_FILE(/home/mysql/testfile));
UPDATE tests
SET Data =
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)
Hi!
I am stuck with the load_file problem...
I have created the following table :
create table table_name (field_number1 int unsigned primary key not
null, data_field longblob not null);
I then tried to load the contents of a file with permissions -rw-r--r--
located in the /home/user directory
Milivojevic
Cc: [EMAIL PROTECTED]
Subject: load_file problem
Hi!
I am stuck with the load_file problem...
I have created the following table :
create table table_name (field_number1 int unsigned primary key not
null, data_field longblob not null);
I then tried to load the contents of a file
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 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) values
(1,load_file('/absolute/path/file_name.jpg'));
sorry abt the error guys..
but guys this still returns a NULL value. please help.
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 tried to
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