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 on my Red Hat 7.1 version of linux
using the following statements...
insert into table_name values (1, load_file('/home/user/file_name'));
or
insert into table_name values (1, load_file("/home/user/file_name"));
(both produce the same result)
it gives me an error that a null cannot be stored as I set it that way
in the table creation statement. It also means that the load_file
function is returning a null.
I am using the 3.23.36 of mysql. I need suggestions.
Thank you
Venu
=====
============================================================
Venugopal Allavatam Ph: (res.): 949-361-6604
1100 Calle Del Cerro, (mobile): 949-842-1767
Apt.# 123-J,
San Clemente, CA-92672 E-mail: [EMAIL PROTECTED]
[EMAIL PROTECTED]
============================================================
__________________________________________________
Do You Yahoo!?
Find a job, post your resume.
http://careers.yahoo.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
