On Wed, 14 Nov 2001, Carlos Alberto Afranllie wrote: > I need to insert files of images in a table, which has a field of > type BLOB, I have understood that to do this I can use the function > LOAD_FILE(file.bmp), but that this file must be in the server. It is not > possible to insert a file that is in a local machine?
Not with LOAD_FILE, according to the Manual. You must do it inside your application i.e. read the file and generate the corresponding SQL statement using your programmatic means. Do not forget to escape the necessary characters (NUL, \, ', ", I think). -- , M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121 A M A D O Rua Campo Alegre, 823 fax 351+226003654 A L V E S P-4150 PORTO, Portugal mob 351+939354002 --------------------------------------------------------------------- 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
