List:General Discussion« Previous MessageNext Message »
From:Alex Safonov Date:October 1 2002 5:40pm
Subject:Store pictures in DB (load_file() revisited)
View as plain text  
Greetings,

just saw a message with an example of inserting a BLOB
value using load_file(). Can't get load_file() to
work:

mysql> select load_file('/home/alex/post.html') from
test;
+-----------------------------------+
| load_file('/home/alex/post.html') |
+-----------------------------------+
| NULL                              |
+-----------------------------------+
1 row in set (0.00 sec)

/home/alex/post.html exists, is small (~1k) and
world-readable. load_file() still returns NULL. Same
if I try to insert an existing file into a table.

I am on Linux 2.4.10 (SuSE), MySQL 3.23.52.

Thanks for any suggestions,


__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com
Thread
Store pictures in DB (load_file() revisited)Alex Safonov1 Oct
  • Re: Store pictures in DB (load_file() revisited)gerald_clark2 Oct