Re: Re: pics in MySQL

[deepak yadav <deepak2000@xxxxxxxxxxxx>]

hi
i never tried that out. i read that in documentation which comes along MySQL

_______
deepak

At 7/20/00 11:16:00 AM, you wrote:
>hi
>  I tried this thing but it did not work.
>It says syntax error at line.
>if i remove the LOAD_FILE thing it works but stores the
>string.
>vinu
>On Tue, 18 Jul 2000 14:24:55 +0500
> deepak yadav <deepak2000@xxxxxxxxxxxx> wrote:
>> *This message was transferred with a trial version of
>> CommuniGate(tm) Pro*
>> 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.
>> 
>> 
>> -----------------------------------------------------------------------
>> The LIP mailing list archives are available at:
>> http://lists.linux-india.org/cgi-bin/wilma/linux-india-programmers
>
>
>-----------------------------------------------------------------------
>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

-- Everything is actually everything else, just recycled.