View Single Post

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

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.

Can anyone see what is wrong with this code? Thanks in advance for
your assistance!!

--nevin

Reply With Quote