Yes, the image file is on the server and i already
chown and chrgp to mysql for this file. Still the data
is null in the table.
--- gerald_clark <[EMAIL PROTECTED]>
wrote:
>
>
> 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]
>
__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
