Re: Fw: LOAD_FILE does not work

2001-11-21 Thread Mike(mickalo)Blezien
On Wed, 21 Nov 2001 17:02:29 -0500, Christopher Book <[EMAIL PROTECTED]> wrote: UPDATE Software SET Description = >>LOAD_FILE(/usr2/home/khan/www/cgibin/protecting/Describe/description_file) >>WHERE ID = 9 >> >>You have to make sure that not only can mysql read the file, but it also has >>

Fw: LOAD_FILE does not work

2001-11-21 Thread Christopher Book
>>UPDATE Software SET Description = LOAD_FILE(/usr2/home/khan/www/cgibin/protecting/Describe/description_file) WHERE ID = 9 You have to make sure that not only can mysql read the file, but it also has permissions to the directories that the files are in. Typically your home directory on your se

Fw: LOAD_FILE does not work

2001-11-21 Thread Sharaaz Khan
I have been trying to load the textual contents of a file from my hard drive space into a field (Description) of my mySQL table (Software) using the follwing query. The query runs succfessfully, however, none of the contents are loaded into the field, in fact, the Description field is not updated