Mark Lo writes:
> Hi,
>
> Now, I know how to insert and update. Then what is the syntax for retirve
> the image file so that it can be shown on the web.
>
> Thank you so much
>
> Mark
>
Hi!
You can use Perl or PHP or C++ for the purpose and with Apache and
Apache-like WWW servers just shoot out a picture to stdout, or you can
go an indirect way and first SELECT ... INTO DUMPFILE, and then
present that file on WWW page.
Second program on this page shows how to send a picture to stdout in
MySQL++:
http://www.mysql.com/mysql++-examples.html
Regards,
Sinisa
+----------------------------------------------------------------------+
| ____ __ _____ _____ ___ == MySQL AB |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sinisa@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+----------------------------------------------------------------------+