Re: Insert Image content via command line

[gerald_clark]

Titu Kim wrote:

Hi,
   I am trying to insert an image directly from
command line into mysql table. My table looks like
==============
Create table ImageTab (id int, content longblob);
===========================
I login to localhost. I have an image at /tmp. Then i
issue this query
================
insert into ImageTab values(1,
load_file("/tmp/myimg.gif"));
==================
No error. But when i check the content of the table,
the content column is null. I login as root to do
this.
What have i done wrong? Please help.
Thanks.
 

The file must be on the server, and readable by the user 'mysql'

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]