Re: using blobs...

["Stephen Adler" <user=65@nabble.blu.org>]

thank you, thank you, thank you! Just what I was looking for... 

John Abreau wrote: 
> LOAD_FILE() should work. Note that it doesn't seem to support relative 
> paths. ALso note that if you display the row, it will vomit the raw file 
> contents all over your tty, triggering much weirdness as your tty 
> misinterprets much of it as terminal control characters. 
> 
> 
>     mysql> insert into foo (blob_col) values ( LOAD_FILE('/tmp/foo.doc') ); 
> 
>     mysql> update foo set blob_col = LOAD_FILE('/tmp/foo.doc') where id = 1; 
> 
> 
> 
> On Mon, Apr 21, 2008 at 12:47 PM, Stephen Adler <[hidden email]> wrote: 
>   
>> Hi Blu! (Happy Boston Marathon day...) 
>> 
>>  I'm spending the day playing around with a DB schema in which I want to 
>> store word document files in blob fields in one of my tables. I want to test 
>> my db schema by issuing sql command at the mysql prompt. So the question I 
>> have, is how can I insert a .doc file into my database using the mysql 
>> command line interface? I've spotted a bunch of visual basic, C# and php 
>> examples of how to stuff a bunch of bits into the blob field, but they all 
>> seem to involve defining some large array in which the whole file was read 
>> into, then passing the pointer to the array in the values part of the insert 
>> statement. Does this mean that I have to write code in order to stuff bits 
>> into the field? 
>> 
>>  Thanks in advance... 
>> 
>>  Cheers. Steve. 
>> 
>> 
>> 
>> 
>>  -- 
>>  This message has been scanned for viruses and 
>>  dangerous content by MailScanner, and is 
>>  believed to be clean. 
>> 
>>  _______________________________________________ 
>>  Discuss mailing list 
>>  [hidden email] 
>>  http://lists.blu.org/mailman/listinfo/discuss
>> 
>>     
> 
> 
> 
>