Extracting images from blob fields.

2004-01-04 Thread Richard Davies 
I have a small single user database into which I wish to insert and extract 
images.

From the manual this seems to work to insert the image

insert into images values(LOAD_FILE(/home/richard/scan.tiff));

but how do I get it back again?

I thought this might work but it doesn't

select * into outfile /home/richard/image.tiff from images;

Note this is an experimental database having at present only one table with 
one field in the table and one record in the database.

The file image.tiff seems to be full of escape characters when viewed with a 
binary editor.

I can find nothing in the manual about how to retrieve the image and searching 
on the web only gives suggestions using perl, php etc to serve it to a web 
page but I don't have perl, php, apache etc I just want to extract the image 
and look at it with image magic or similar.

Any advice will be greatly appreciated.

-- 
Regards

Richard


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Extracting images from blob fields.

2004-01-04 Thread robert_rowe 

You need to select into dumpfile instead of outfile. See the section of the manual on 
select syntax:

http://www.mysql.com/doc/en/SELECT.html

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]