> 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 even possible, to grab the >>content from the file and use it in the following update statement? >> >>mysql>update research set publications='loooong text in a file' where >>uid=319; >> >>Any ideas? >> >>Thanks in advance, >> >>Bing > > Bing, > You could create a temporary table with a single text field and > then use "Load Data Infile <filepath> ..." to put the text data into the > temporary table. Once it is there you can use the temporary table to > update > your research table. >
That sounds like a good idea that's worth trying. Thanks much, Mike. Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
