Hi
I have question:
How can i upload the pictures to the mysql server in windows

I know there are a lot of script out there (PHP), but i need to do it like when i create table in mysql
mysql>create table.... (I don't want to do it with php, do it with mysql)
and I aready know the blob way or put the name of the pictures in to mysql table (but the problem is blob is too slow)
is anybody knows how to do it?

Thank You
Best Regards
mani_he

Any help
Thanks

i think that using blobs in mysql is very inefficient and slow. the best way to do is to store just image source in mysql table...

Thanks Moharo for your reply
So you mean just store the address of my image to mysql table, Right?

Thanks
Best Regards

There's a pretty big debate about whether it's better to store the raw image data vs. a filename in the database. Personally, I prefer to store the path in the database, since it's generally the filename you need when generating the <img> tags in your HTML documents, not the actual binary image data.

One of the most frequently mentioned arguments FOR storing binary data in the database is that it makes it easier to migrate your site from one server to another. My response to that is that one generally doesn't migrate their sites all that often, and if they do, the extra effort is simply zipping up the filesystem that stores the images and extracting it on your new server. Usually this is pretty painless, so long as the paths you store in the database are relative. If you store an absolute path in your database, then yeah, it becomes more of a headache to convert these to match the absolute path on your new server. Still, this can be done with a really really really simple/short PHP script or database query.


Take care,

Nik
http://www.bigaction.org/

Thanks
Your answer is really good and i will store the path in mysql instead of storing image.

Thanks
Regards