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]