Hello everybody,
I know it has been covered before. I read the manual, I folow the examples,
and I am still having problems. What I want is store a blob in a blob field,
so:
CREATE TABLE blobtest ( name CHAR(5), myblob MEDIUMBLOB );
Query Ok.
INSERT INTO blobtest VALUES ( '1', LOAD_FILE('/root/.profile') );
Query Ok, 1 row affected.
SELECT * FROM blobtest;
+-------+---------------------+
| Name | myblob |
+-------+---------------------+
| 1 | NULL |
+------+----------------------+
I've tried LOAD_FILE with many other files, including files in world-readable
directories, and I always get the same result.
Am I missing something ?
--
Joćo Paulo Vasconcellos
Gerente de Tecnologia - NetCard
Tel. 21 3852-9008 Ramal 31
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
