MySQL Forums
Forum List  »  Newbie

Re: How can i Extract LongText Images
Posted by: Peter Brawley
Date: February 08, 2019 09:48AM

Then you'll need to write a query to extract each into a .jpg file, something like if the table's pk is id ...

select txtcolname character set ... into outfile 'id.jpg' where id=1;

... then have your report writer fetch that image.

Options: ReplyQuote


Subject
Written By
Posted
Re: How can i Extract LongText Images
February 08, 2019 09:48AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.