Re: Re: pics in MySQL

[deepak yadav <deepak2000@xxxxxxxxxxxx>]

hi
i found out how to do that in mysql. use following sql statement for mysql , it may work for u

UPDATE table_name SET blob_column=LOAD_FILE("/tmp/picture") WHERE id=1;

__________
deepak

At 7/18/00 1:20:00 PM, you wrote:
>Do you have any examples on how to store an image in 
>binary form.The GUI i am using is Java(jdbc connection)
>so tell me how to connect and store the image in
>db.
>vinu
>On Tue, 18 Jul 2000 11:46:27 +0530
> Paramdeep Singh <PSingh@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>> *This message was transferred with a trial version of
>> CommuniGate(tm) Pro*
>> Yes
>> you do have in Oracle.
>> 
>> and exact way of storing depends on the version you are
>> using of oracle.
>> 
>> The oldest available oracle version shall support
>> LongRaw(upto 2G) binary
>> dat.
>> and 8 ,8i have sepcial facilities for storing multimedia
>> content 
>> 
>> Param
>> 
>> 
>> 
>> -----Original Message-----
>> From: Linux List [mailto:linux-prog@xxxxxxxxx]
>> Sent: Tuesday, July 18, 2000 11:45 AM
>> To: linux-india-programmers@xxxxxxxxxxxxxxxxxxxxx
>> Subject: Re: [LIP] pics in MySQL
>> 
>> 
>> hi
>>   Wanted to ask the same.U have some think like that in 
>> Oracle.Do you have somethink like that for PostGRESQl.
>> I want  to store the images in binary form in the
>> database.
>> vinu
>> 
>> On Sat, 17 Jun 2000 10:32:27 +0530
>>  "Muthu" <muthu@xxxxxxxxxxxxxxxxxx> wrote:
>> > *This message was transferred with a trial version of
>> > CommuniGate(tm) Pro*
>> > Hai deepak,
>> > 
>> >     Use Blob data type to store images.One way of
>> > updating the image in
>> > datafield is , Open the image file and read chunks of
>> > bytes (say 1024) and
>> > update the blob datafield.
>> > 
>> > i hope the above information will help you
>> > 
>> > with regards
>> > Muthukumar
>> > 
>> > > hi
>> > > i want to store pictures in MySQL database. what kind
>> > of data type is to
>> > be used. and how to go about storing it .
>> > > please help . a small code would be very helpful.
>> > >
>> > > reply soon
>> > > bye
>> > >
>> > >  __ deepak __
>> > >
>> > > have a great day
>> > > ICQ 30662394
>> > >
>> > > -- Try not to let implementation details sneak into
>> > design documents.
>> > >
>> > >
>> > > -----------------------------------------------------------------------
>> > > The LIP mailing list archives are available at:
>> > > http://lists.linux-india.org/cgi-bin/wilma/linux-india-programmers
>> > 
>> > 
>> > -----------------------------------------------------------------------
>> > For more information on the LIP mailing list see:
>> > http://lists.linux-india.org/lists/LIP
>> 
>> 
>> -----------------------------------------------------------------------
>> For information on this and other Linux India mailing
>> lists check out
>> http://lists.linux-india.org/
>> 
>> -----------------------------------------------------------------------
>> For more information on the LIP mailing list see:
>> http://lists.linux-india.org/lists/LIP
>
>
>-----------------------------------------------------------------------
>The LIP mailing list archives are available at:
>http://lists.linux-india.org/cgi-bin/wilma/linux-india-programmers
>
>

-----------------------------
reply soon
bye

 __ deepak __

have a great day 
ICQ 30662394

-- No program done by an undergrad will work after she graduates.