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
sinisa@stripped wrote:
> Dr. Dieter Becker writes:
> > Thank You very much,
> >
> > but there rests a little question. How to insert this binary file in a
> > defined row? All other data are in this row, only the binary file must be
> > inserted?
> >
> > Dieter
> >
> > Dr. med. Dipl.-Math. Dieter Becker
> > Medizinische Universitäts- und Poliklinik
> > Innere Medizin III
> > D66421 Homburg
>
> HI!
>
> You mean to update an existing row ??
>
> Like this:
>
> update binbin set binfield=load_file("/tmp/bindata.bin") where
> primary_key=......;
>
> Regards,
>
> Sinisa
>
> +----------------------------------------------------------------------+
> | ____ __ _____ _____ ___ == MySQL AB |
> | /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic |
> | /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sinisa@stripped |
> | /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus |
> | /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
> | ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
> | /*/ \*\ Developers Team |
> +----------------------------------------------------------------------+
>
> --
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/php/manual.php3" before
> posting. To request this thread, e-mail mysql-thread40960@stripped
>
> To unsubscribe, send a message to:
> <mysql-unsubscribe-markloky=netvigator.com@stripped>
