Hi,
You should use the LOAD_FILE fonction to load your documents in the BLOB
field.
Ex: UPDATE table_name SET blob_column=LOAD_FILE("/some/where/picture");
You could find better explaination of that fonction in the manual at:
http://www.mysql.com/doc/S/t/String_functions.html
Regards,
S�bastien DIDIER
Zarcrom SAS - Web Hosting
www.zarcrom.fr
> -----Message d'origine-----
> De : Dang Nguyen [mailto:[EMAIL PROTECTED]]
> Envoy� : lundi 4 mars 2002 20:05
> � : Mysql List (E-mail)
> Objet : storing files in mySQL
>
>
> Hi everyone,
>
> I'd like to know how to load files, such as MS-Word documents or PDF
> documents, in a mySQL database. I've setup a blob type in a table, but
> where do I go from there?
>
> The purpose of this is to store files uploaded from a web page
> and processed
> with Java servlets. Then, the files should be retrievable (displayed or
> downloaded) back to a client browser. My environment: Apache Web server
> 1.3.x on Solaris 2.8 with Java servlets environment.
>
>
> Thanks for any help,
> Dang Nguyen
>
---------------------------------------------------------------------
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
