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 |