For real-life example, check out http://cdbaza.ultracgis.com, and check
out the filename
of the thumbnails images. I'm SELECTing those images from the MySQL
database.
That's how it's done:
1_ Create a table to store your JPGs, and the column that holds JPG data
should be declared as BLOB
Sameer,
Monday, May 20, 2002, 11:17:48 AM, you wrote:
SM Can you please put some light on it.. How i can do it, or is
SM it described in manual
You can insert file into BLOB field using INSERT statement and
retrieve file using SELECT.
To insert file you can use LOAD_FILE() function:
Hi,
That explains me a problem but i could not see strmov()
function any where, while linking with -lmysqlclient also
it gives unreferenced function..
I am using Mysql 3.23
Please help
Sameer
--
you wrote:
Sameer,
Monday, May 20, 2002, 11:17:48 AM, you wrote:
SM Can you please
[EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, May 20, 2002 12:26 AM
Subject: Re: store JPG in MySQL DB
For real-life example, check out http://cdbaza.ultracgis.com, and check
out the filename
of the thumbnails images. I'm SELECTing those images from the MySQL
database.
That's how it's
wouldn't use it.
Andrei Cojocaru
[EMAIL PROTECTED]
- Original Message -
From: Sherzod B. Ruzmetov [EMAIL PROTECTED]
To: Andrei Cojocaru [EMAIL PROTECTED]
Cc: Sameer Maggon [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, May 20, 2002 9:37 AM
Subject: Re: store JPG in MySQL DB
Hi
PROTECTED]
Cc: Sameer Maggon [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, May 20, 2002 9:37 AM
Subject: Re: store JPG in MySQL DB
Hi Andrei
If I were you I would not store a binary file into the database, I'd
store
the information required to fetch it from somewhere else like
) to their profile.
Thanks so much,
Soheil
-Original Message-
From: Sherzod B. Ruzmetov [mailto:[EMAIL PROTECTED]]
Sent: Mon, May 20, 2002 8:37 AM
To: Andrei Cojocaru
Cc: Sameer Maggon; [EMAIL PROTECTED]
Subject: Re: store JPG in MySQL DB
Hi Andrei
If I were you I would not store
PROTECTED]
Sent: Monday, May 20, 2002 9:54 AM
Subject: Re: store JPG in MySQL DB
Hi Andrei
well, let's just say if it crashes it will mean longer recovery time,
you
are adding extra processing to the SQL server to handle data it wasn't
meant
to handle, storing it in the file system has the main
, May 20, 2002 9:37 AM
Subject: Re: store JPG in MySQL DB
Hi Andrei
If I were you I would not store a binary file into the database, I'd
store
the information required to fetch it from somewhere else like the mySQL
manual suggests
But what difference does it make? Besides, I found storing
Hi
Hi,
Can i have a table in which i can store my JPG file somehow in
MYSQL database.
Absolutely.
just declare a BLOB column, and load your images rightinto the columsn
Sameer
--
http://www.dypatil.edu For Better tomorrow
Hi,
Can you please put some light on it.. How i can do it, or is
it described in manual
Sameer
--
you wrote:
Hi
Hi,
Can i have a table in which i can store my JPG file somehow in
MYSQL database.
Absolutely.
just declare a BLOB column, and load your images rightinto the
11 matches
Mail list logo