List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:November 12 2001 3:32pm
Subject:Re: load_file problem
View as plain text  
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) values
>> (1,load_file('/absolute/path/file_name.jpg'));
> 
> 
> sorry abt the error guys..
> but guys this still returns a NULL value. please help.
> thanks!
> 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: allaven@stripped
>                                      a_n_venugopal@stripped
> ============================================================
> 
> __________________________________________________
> 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 <mysql-thread90834@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> 
> 

Thread
load_file problemVenugopal Allavatam10 Nov
  • Re: load_file problemGerald Clark12 Nov