From: Héctor Maldonado (hmmtci.net.pe)
Date: Thu Jul 01 2004 - 10:06:46 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi all!..

How can I insert blob data (specifically a jpg image) into a blob field
remotely?.. I mean, the client has to choose a jpg image in his/her PC
and upload it to the server.

I found this piece of code:

INSERT INTO car_models
        (Brand, Picture)
VALUES
        ('Subaru Impreza', LOAD_FILE('/somepath/impreza.jpg'));

But LOAD_FILE only works if 'picture.jpg' is placed on the same machine
where the server is running.

Any Idea?

Thanks in Advance

Hector.
        
--
Ing. Héctor Maldonado Melgar
Dpto. Desarrollo de Software
TCI S.A., Lima-Perú
hmmtci.net.pe
Of.: 421-3222
Cel: 9503-9205

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]