View Single Post

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

nevin wrote:
> Hi All,
>
> I am new to this list as well as MySQL in general. I am trying to
> insert a blob file into a simple table. the table has 4 variables
> (name, age,al,ne) and ne is defined as a mediumblob field. I am using
> heidiSQL as a gui for writing this code. here is the code i am using
>
>
> INSERT into nevin (name,age,al,ne)
> VALUES ('Abe',38,2,LOAD_FILE ('c:/program files/MySQL/MySQL Server
> 5.0/data/7184_thumb.jpg');
>
> when i run it i get an error stating. SQL Error: You have an error in
> your SQL syntax.

Is that really all the error message says? It usually gives more information
pointing to where the error is.


Reply With Quote