>From the manual, check:
* the file must be on the server
* you must specify the full pathname to the file (ok, you did this)
* you must have the FILE privilege
* the file must be readable by all and be smaller than
max_allowed_packet
If the file doesn't exist or can't be read due to one of the above
reasons, the function returns NULL.
On Fri, 2004-01-09 at 18:34, mark wrote:
> Table's defined with ... "content TEXT" field, but when I issue the command
> insert into content values ( 'test', '', 'index.html', 1.000,
> 'index.html','','', load_file('/home/projects/URCMS/test/index.html'),
> 'import', now(), 'test', 'import', 0,'');
> either as script input, or from the sql command line, I get rc=0, but when
> I select from the table, what I see is the value of the field named content
> is NULL (and I *did* define it to be NOT NULL).
>
> What am I missing about load_file? I do have the full path to the file to be
> loaded into the TEXT column, and I've tried it with both single and double
> quotes.
>
> mark
> --
> FASCISM. A system of government that exercises a dictatorship of the
> extreme right, typically through the merging of state and business
> leadership, together with belligerent nationalism. -- The American
> Heritage Dictionary Houghton Mifflin Company, 1983
--
Diana Soares
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
