Hello, function load_file always return NULL for me. I tried using INSERT and UPDATE. The file and directory is world readable. Is there a known problem with load_file on mysql 4.0.0 ?
INSERT INTO tests (Name,Data) VALUES ('123.456',LOAD_FILE("/home/mysql/testfile")); UPDATE tests SET Data = "/home/mysql/testfile" WHERE Name = '123.456'; Regards, Fred --------------------------------------------------------------------- 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