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
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]