There is a function called Load_File which will cause the mysqld to read the file into a field. It is designed for such things. Check out http://www.mysqldeveloper.com/faqs/index.pcgi?id=7 for more information.
Keep in mind that generally it is better to use the file system to store files and the database to store data. The preferred way to do this with images is to just keep track of the name and location of the file in the database. Good luck with your application. Harrison ----- Original Message ----- From: "Info_Best-IT" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 21, 2002 10:54 AM Subject: Inserting images and other blobs > Any suggestions on how to load images from a web site into a MySQL db? I would like > to set up a page that allows you to select an image from the local machine and load > it to my MySQL DB on my web server. > > I'm not sure if it would just be a regular insert statement or something else? > > Thanks... > /Tim > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
