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. |