yogesh.kadalgikar

------=_NextPart_000_0025_01C360BB.98595CD0
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Hello All,

Let me put it this way.
I have created a database with name PICTURE
mysql>CREATE DATABASE PICTURE

After using the database I created a table of the type below:

create table PictureFile(Index int(11) not null primary key, PictureFile =
Blob)type=3Dinnodb;

Now I have a file named star.jpg in c: drive of my system
I need to store the whole file into the database.=20

Hence I required to know the syntax of the query to store that file and =
similarly the other way to retrive it back too.

Can any one help me out with this problem.
Thanking you in advance,

Regards,
Yogesh

------=_NextPart_000_0025_01C360BB.98595CD0--

joachim

1. In a web-based form
Will you store images (jpg,gif,png) then look at the following:
http://www.phpbuilder.net/columns/florian19991014.php3
For a gallery in a mysql-db look under
http://www.geek247.net/gallery/=09
2. From the Command-Line
look in the docu of mysql=20
I think it=C2=B4s possible

Joachim


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dmysql-win32@freebsd.csie.nctu.edu.tw