insert images into mysql db

[peterb1985]

Does anyone know how i write an insert query to add jpg images to my database table.

 

[vacunita]

IT's usually not a good idea to keep images in a DB but rather keep the links to the images. and store the images in a folder on the server.

The field would then only contain a link the image.

Such as: \imagefolder\myimage.jpg

And the insert would be a normal insert Insert INTO mytable imagelinkfieldname values("\imagefolder\image.jpg");

If you must really insert an image into a DB look into the Blob datatype. in the MYSQL online manual.

http://dev.mysql.com/doc/refman/5.0/en/blob.html

----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[peterb1985]

Thanks for the link. You don't happen to have the actual query i need to use to insert them do you?

I seen that in a lot of forums that you should only store the pointer and not the image.

I needed to use the image because i'm using crystal reports 9 which cannot read file pointers and display the image. According to Crystal's website the only work around for version 9 is to store the images in a database. Apparently version 11 can read file pointers.

If you know of anyway to get different images for each record in crystal reports, please let me know.

 

[vacunita]

Something like this:

nsert into mytable values (load_file("\location\of\file\in\server\file.jpeg"));

----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.