From: Victor Pendleton (VPendletonhoovers.com)
Date: Thu Jul 01 2004 - 15:48:23 CDT

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

Is using a programming language such as Java, PHP or VB an option?

-----Original Message-----
From: Héctor Maldonado
To: mysqllists.mysql.com; Omar De la Cruz
Sent: 7/1/04 10:06 AM
Subject: how to insert blob data remotely

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
To unsubscribe:
http://lists.mysql.com/mysql?unsub=VPendletonhoovers.com

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

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