Re: retrieve value from an external file?

2006-07-21 Thread Bing Du
> At 02:48 PM 7/20/2006, you wrote: >>Hello everyone, >> >>Without scripting, can this be done from mysql> command line? The >>'publications' field is mediumtext in table 'research'. Since >>'publication' is pretty long, I want to save it in a file on the file >>system. But I don't know how, or

Re: retrieve value from an external file?

2006-07-21 Thread Bing Du
> On Thursday 20 July 2006 12:48 pm, Bing Du wrote: >> Hello everyone, > >> mysql>update research set publications='lng text in a file' where >> uid=319; > > You already have the data in a storage system ( a file on the filesystem > ). > That said, use what you have, store the location to the f

Re: retrieve value from an external file?

2006-07-20 Thread mos
At 02:48 PM 7/20/2006, you wrote: Hello everyone, Without scripting, can this be done from mysql> command line? The 'publications' field is mediumtext in table 'research'. Since 'publication' is pretty long, I want to save it in a file on the file system. But I don't know how, or if that's ev

Re: retrieve value from an external file?

2006-07-20 Thread Chris White
On Thursday 20 July 2006 12:48 pm, Bing Du wrote: > Hello everyone, > mysql>update research set publications='lng text in a file' where > uid=319; You already have the data in a storage system ( a file on the filesystem ). That said, use what you have, store the location to the file, then g

retrieve value from an external file?

2006-07-20 Thread Bing Du
Hello everyone, Without scripting, can this be done from mysql> command line? The 'publications' field is mediumtext in table 'research'. Since 'publication' is pretty long, I want to save it in a file on the file system. But I don't know how, or if that's even possible, to grab the content fro