View Single Post

   
  #4 (permalink)  
Old 02-28-2008, 11:29 AM
nevin
 
Posts: n/a
Default Re: newbie blob LOAD_FILE issue

Hi All,

I solved it!! simple mistake really all i needed to do was add the
extra ) at the end of the load_file statement,
and the clincher was that there was an extra space in my original code
between LOAD_FILE and the opening (
when i removed this space, it worked!! here is the working code.

INSERT into nevin (name,age,al,ne)
VALUES ('JAMES',38,2,LOAD_FILE('c:/program files/MySQL/MySQL
Server 5.0/data/7184_thumb.jpg'));

thanks !

--nevin

Reply With Quote