Re: pics in MySQL

["Linux List " <linux-prog@xxxxxxxxx>]

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