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 |